Search found 116 matches
- Tue Sep 29, 2020 8:21 pm
- Forum: PlanMaker 2021 for Windows
- Topic: open worksheets of unknown count in same workbook
- Replies: 5
- Views: 2310
Re: open worksheets of unknown count in same workbook
Well I've pratted about for quite a few hours but up to now have not managed to so what I want. If someone has the time to spend 10 minutes or what you can spare to tell how to do it please. I have done nothing more that confuse myself with all this modern referencing and linking to other worksheets...
- Tue Sep 29, 2020 8:11 pm
- Forum: TextMaker 2021 for Windows
- Topic: Graphics on labels???
- Replies: 7
- Views: 2774
Graphics on labels???
HI,
Just wondering if the above function actually got added as I can't see it in the help files.
The ability to include an image or graphic on labels, then apply a database to the print run?
Anyone have the answer to that please?
Just wondering if the above function actually got added as I can't see it in the help files.
The ability to include an image or graphic on labels, then apply a database to the print run?
Anyone have the answer to that please?
- Mon Sep 14, 2020 4:37 pm
- Forum: PlanMaker 2021 for Windows
- Topic: Dropdown list from another workbook
- Replies: 4
- Views: 3053
Re: Dropdown list from another workbook
Hi
Well thanks for that, in some way your suggested method may be easier than actually having the ability to reference a different workbook. I will give it a try shortly and see how it goes.
Regards
Well thanks for that, in some way your suggested method may be easier than actually having the ability to reference a different workbook. I will give it a try shortly and see how it goes.
Regards
- Mon Sep 14, 2020 1:10 pm
- Forum: PlanMaker 2021 for Windows
- Topic: Dropdown list from another workbook
- Replies: 4
- Views: 3053
Re: Dropdown list from another workbook
Thanks for the reply. Do you know if it something on the development list for future? I have a supplier list which is common to three workbooks , so I assume I will have to 'update' three lists on three workbooks every-time there is a new supplier added? Unless there is a way that I can do it anothe...
- Mon Sep 14, 2020 12:21 am
- Forum: PlanMaker 2021 for Windows
- Topic: Dropdown list from another workbook
- Replies: 4
- Views: 3053
Dropdown list from another workbook
Hi,
Using Input validation ...
is it possible to create a drop-down list on a worksheet in workbook A using information from workbook B?
I've been trying but I can't manage it using the standard procedure I would in the same workbook.
Regards
Using Input validation ...
is it possible to create a drop-down list on a worksheet in workbook A using information from workbook B?
I've been trying but I can't manage it using the standard procedure I would in the same workbook.
Regards
- Sun Sep 06, 2020 12:29 pm
- Forum: PlanMaker 2018 for Windows
- Topic: worksheet action from a link activation?
- Replies: 6
- Views: 5662
Re: worksheet action from a link activation?
Supertech,
thanks for that, I'll follow my other line of enquiry and use the BasicMaker idea.
Might take a while, but lockdown being what it is
thanks for that, I'll follow my other line of enquiry and use the BasicMaker idea.
Might take a while, but lockdown being what it is
- Sat Sep 05, 2020 8:53 pm
- Forum: PlanMaker 2018 for Windows
- Topic: Activate script via a button - is it going to happen?
- Replies: 8
- Views: 9368
Re: Activate script via a button - is it going to happen?
Supertech
Thanks for that
Should I be able to write a piece of BAS code that will insert a time and a date into the workbook. AND also open a workbook specified by the cell?
Thanks for that
Should I be able to write a piece of BAS code that will insert a time and a date into the workbook. AND also open a workbook specified by the cell?
- Sat Sep 05, 2020 8:36 pm
- Forum: PlanMaker 2018 for Windows
- Topic: worksheet action from a link activation?
- Replies: 6
- Views: 5662
Re: worksheet action from a link activation?
Hi rather than make it too complex with all my files I've knocked up a quick three file text as attached in a zip.
Hope it makes sense
Using the MyMainWorksheet as the main entry workbook.
Hope it makes sense
Using the MyMainWorksheet as the main entry workbook.
- Sat Sep 05, 2020 6:35 pm
- Forum: PlanMaker 2018 for Windows
- Topic: worksheet action from a link activation?
- Replies: 6
- Views: 5662
Re: worksheet action from a link activation?
Hi Supertech Think I may have mis asked the question. the links are in B2:B50 however the dates are in D2:D20 So I would be changing only data in the D range but pressing the B range. Hope that makes sense.. I have a feeling I will have to some how write some code, but no idea how I would use it on ...
- Sat Sep 05, 2020 11:28 am
- Forum: PlanMaker 2018 for Windows
- Topic: worksheet action from a link activation?
- Replies: 6
- Views: 5662
worksheet action from a link activation?
HI,
I have a main sheet of subjects all of which are links to other workbooks. On the same page I have to enter the date last visited.
Is it possible to click on a link and the software update a field with today's date and time. Without code?
I have a main sheet of subjects all of which are links to other workbooks. On the same page I have to enter the date last visited.
Is it possible to click on a link and the software update a field with today's date and time. Without code?
- Sat Sep 05, 2020 11:24 am
- Forum: PlanMaker 2018 for Windows
- Topic: Activate script via a button - is it going to happen?
- Replies: 8
- Views: 9368
Re: Activate script via a button - is it going to happen?
Hi Jcrey,
Sorry, but I got distracted on to a couple of other projects. So as yet I have no information. If I get any I'll put it here.
I'm just about to put another similar question on the group.
regards
Sorry, but I got distracted on to a couple of other projects. So as yet I have no information. If I get any I'll put it here.
I'm just about to put another similar question on the group.
regards
- Wed Aug 19, 2020 10:11 pm
- Forum: PlanMaker 2021 for Windows
- Topic: open worksheets of unknown count in same workbook
- Replies: 5
- Views: 2310
Re: open worksheets of unknown count in same workbook
Thanks Martin-k
Will feedback later, sorry but probably with a follow up question.
Will feedback later, sorry but probably with a follow up question.
- Tue Aug 18, 2020 9:40 pm
- Forum: PlanMaker 2021 for Windows
- Topic: open worksheets of unknown count in same workbook
- Replies: 5
- Views: 2310
Re: open worksheets of unknown count in same workbook
HI Supertech,
Thanks, however I had hoped for a few more hints on the subject.
But never mind, thanks for responding
Thanks, however I had hoped for a few more hints on the subject.
But never mind, thanks for responding
- Tue Aug 18, 2020 11:59 am
- Forum: PlanMaker 2021 for Windows
- Topic: open worksheets of unknown count in same workbook
- Replies: 5
- Views: 2310
open worksheets of unknown count in same workbook
HI, How would I manage to open a list of x number of worksheets all in the same workbook, access a couple of fields and add them to a summary field on a new workbook. The worksheets are going to be fixed format titles, such as Invoice 20200811-01, Invoice 20200812-02 How do I work out how many there...
- Wed Feb 05, 2020 4:37 am
- Forum: PlanMaker 2018 for Windows
- Topic: circular reference error
- Replies: 2
- Views: 2747
Re: circular reference error
Thanks Miguel
Sorry for the delay, been ill again. 'Old age does not come alone'
Sorted now.
Regards
Sorry for the delay, been ill again. 'Old age does not come alone'
Sorted now.
Regards