Thanks for that,
I'm testing and have 90% success rate, but that's me, I think I am doing things in the wrong order. The last few times tested seem to have worked OK.
great result for me, again thanks for the assist with that one.
Search found 124 matches
- Mon Mar 31, 2025 8:32 pm
- Forum: PlanMaker NX and 2024 for Windows
- Topic: how to ref or find the last active cell in a column or row?
- Replies: 4
- Views: 20854
- Thu Mar 27, 2025 11:49 am
- Forum: PlanMaker NX and 2024 for Windows
- Topic: how to ref or find the last active cell in a column or row?
- Replies: 4
- Views: 20854
Re: how to ref or find the last active cell in a column or row?
Hi Supertech, thanks for the reply. I'm looking at making entries numerous times daily, showing date, time, and two columns of data. Possibly as if interest rates/prices change as and when (some days no entry). I must find the latest entry in the 4 columns (Col A). Is there a way of finding the firs...
- Sun Mar 16, 2025 7:00 pm
- Forum: PlanMaker NX and 2024 for Windows
- Topic: how to ref or find the last active cell in a column or row?
- Replies: 4
- Views: 20854
how to ref or find the last active cell in a column or row?
It's a while ago, but still have no real answer.
How do you get a cell ID, which is the final active cell in a row or column?
How do you get a cell ID, which is the final active cell in a row or column?
- Sat Jan 04, 2025 10:28 am
- Forum: PlanMaker NX and 2024 for Windows
- Topic: change a row text colour when a cell = value x
- Replies: 3
- Views: 10381
Re: change a row text colour when a cell = value x
Sorry for my absence, Christmas, New Year and family have been a priority.
Seasons greetings to you all.
I need another two days to get back on track with this problem.
Note: After Supertech asked I uploaded a small file, which I can't see on this forum. I'll re-upload soon.
Regards
Princy557
Seasons greetings to you all.
I need another two days to get back on track with this problem.
Note: After Supertech asked I uploaded a small file, which I can't see on this forum. I'll re-upload soon.
Regards
Princy557
- Fri Dec 20, 2024 11:37 am
- Forum: PlanMaker NX and 2024 for Windows
- Topic: Inserting day before
- Replies: 3
- Views: 9141
Re: Inserting day before
Thanks for the reply
Ditto.
So there's a nice key to use for the day before.
It would be quite handy.
I'm not sure if anyone agrees with me on that one.
Ideally there would have been a cluster of keys, yesterday, today and tomorrow+
Regards
Princy557
Ditto.
So there's a nice key to use for the day before.
It would be quite handy.
I'm not sure if anyone agrees with me on that one.
Ideally there would have been a cluster of keys, yesterday, today and tomorrow+
Regards
Princy557
- Fri Dec 13, 2024 9:18 pm
- Forum: PlanMaker NX and 2024 for Windows
- Topic: Inserting day before
- Replies: 3
- Views: 9141
Inserting day before
Hi,
Whilst I remember I had wondered if as with Ctrl-> gives today's date.
How about Ctrl-< for the previous day's date?
I thought it might have been a popular idea for anyone using date entries when catching up on yesterdays accounts ha ha
Regards
Princy557
Whilst I remember I had wondered if as with Ctrl-> gives today's date.
How about Ctrl-< for the previous day's date?
I thought it might have been a popular idea for anyone using date entries when catching up on yesterdays accounts ha ha
Regards
Princy557
- Fri Dec 13, 2024 9:12 pm
- Forum: PlanMaker NX and 2024 for Windows
- Topic: graphix on mailing labels
- Replies: 1
- Views: 6009
graphix on mailing labels
HI,
Long time ago I requested, suggested, thought was a good idea. The ability to be able to add graphics to labels, tables and lists.
Did anything happen about this?
Adding to that now would be the ability to add an barcode/ QR code/ addresscode.?
Regards
Princy557
Long time ago I requested, suggested, thought was a good idea. The ability to be able to add graphics to labels, tables and lists.
Did anything happen about this?
Adding to that now would be the ability to add an barcode/ QR code/ addresscode.?
Regards
Princy557
- Fri Dec 13, 2024 8:36 pm
- Forum: PlanMaker NX and 2024 for Windows
- Topic: change a row text colour when a cell = value x
- Replies: 3
- Views: 10381
change a row text colour when a cell = value x
Hi, I would like to make a row (5 columns) to change to text color light gray. the action to be triggered by the 5 column value. I already have col2 and col3 triggering the col5 to show as 'COMPLETE'. From that saying complete I also want the row-col1 to 5 to all change to light gray text? How do I ...
- Sun Nov 26, 2023 7:11 pm
- Forum: PlanMaker NX and 2024 for Windows
- Topic: Template for a new page on a worksheet
- Replies: 3
- Views: 17131
Re: Template for a new page on a worksheet
Thanks, Petroben,
Worked a treat, not sure why I missed it! Age me thinks.
Regards
Worked a treat, not sure why I missed it! Age me thinks.
Regards
- Sat Nov 11, 2023 12:41 pm
- Forum: TextMaker NX and 2024 for Windows
- Topic: How to copy options/settings to another computer
- Replies: 2
- Views: 28108
Re: How to copy options/settings to another computer
Thanks Jossi,
Worked a treat, I'd totally missed that one.
Worked a treat, I'd totally missed that one.
- Sat Nov 11, 2023 3:58 am
- Forum: TextMaker NX and 2024 for Windows
- Topic: How to copy options/settings to another computer
- Replies: 2
- Views: 28108
How to copy options/settings to another computer
Hi
I think the subject says it all.
How do I copy the settings to a different computer?
Does it make a difference if it goes from a W10 to a W11 machine?
I think the subject says it all.
How do I copy the settings to a different computer?
Does it make a difference if it goes from a W10 to a W11 machine?
- Tue Nov 07, 2023 5:59 am
- Forum: PlanMaker NX and 2024 for Windows
- Topic: Template for a new page on a worksheet
- Replies: 3
- Views: 17131
Re: Template for a new page on a worksheet
Thanks, Woody44
That's basically what I am doing at the moment.
I was thinking along the lines of multiple-page templates to choose from.
But the way I'm doing it and your suggestion work OK.
Regards
That's basically what I am doing at the moment.
I was thinking along the lines of multiple-page templates to choose from.
But the way I'm doing it and your suggestion work OK.
Regards
- Mon Nov 06, 2023 9:41 pm
- Forum: PlanMaker NX and 2024 for Windows
- Topic: Template for a new page on a worksheet
- Replies: 3
- Views: 17131
Template for a new page on a worksheet
Hi, Brain freeze is in full swing. :o :o The bottom line has the + sign to give you a new worksheet. But, Is there a way to have a worksheet template so that you can add a fixed format form to it? I have a sheet which I want to use as if it were a template itself, currently, I have just got a single...
- Thu Feb 02, 2023 3:34 pm
- Forum: PlanMaker 2021 for Windows
- Topic: Graphs not looking right
- Replies: 1
- Views: 12502
Graphs not looking right
I have a graph which is supposed to show the X (date) and Y (£). Column A carries a date and starts from A15 and ends at A52 (date) column E carries a £ amount starts from E15 and ends at E52 Attached: shows Snap 1 using a different column with another numeric value and show what I was expecting. an...
- Tue Jan 31, 2023 9:25 pm
- Forum: PlanMaker 2021 for Windows
- Topic: How to ref the last cell with data in it in a formula
- Replies: 1
- Views: 12373
Re: How to ref the last cell with data in it in a formula
This seems to work