Search found 131 matches

by Princy557
Mon Sep 14, 2020 4:37 pm
Forum: PlanMaker 2021 for Windows
Topic: Dropdown list from another workbook
Replies: 4
Views: 74

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
by Princy557
Mon Sep 14, 2020 1:10 pm
Forum: PlanMaker 2021 for Windows
Topic: Dropdown list from another workbook
Replies: 4
Views: 74

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...
by Princy557
Mon Sep 14, 2020 12:21 am
Forum: PlanMaker 2021 for Windows
Topic: Dropdown list from another workbook
Replies: 4
Views: 74

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
by Princy557
Sun Sep 06, 2020 12:29 pm
Forum: PlanMaker 2018 for Windows
Topic: worksheet action from a link activation?
Replies: 6
Views: 89

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 :(
by Princy557
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: 1782

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?
by Princy557
Sat Sep 05, 2020 8:36 pm
Forum: PlanMaker 2018 for Windows
Topic: worksheet action from a link activation?
Replies: 6
Views: 89

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.
by Princy557
Sat Sep 05, 2020 6:35 pm
Forum: PlanMaker 2018 for Windows
Topic: worksheet action from a link activation?
Replies: 6
Views: 89

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 ...
by Princy557
Sat Sep 05, 2020 11:28 am
Forum: PlanMaker 2018 for Windows
Topic: worksheet action from a link activation?
Replies: 6
Views: 89

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?
by Princy557
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: 1782

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
by Princy557
Wed Aug 19, 2020 10:11 pm
Forum: PlanMaker 2021 for Windows
Topic: open worksheets of unknown count in same workbook
Replies: 4
Views: 142

Re: open worksheets of unknown count in same workbook

Thanks Martin-k
Will feedback later, sorry but probably with a follow up question.
by Princy557
Tue Aug 18, 2020 9:40 pm
Forum: PlanMaker 2021 for Windows
Topic: open worksheets of unknown count in same workbook
Replies: 4
Views: 142

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
by Princy557
Tue Aug 18, 2020 11:59 am
Forum: PlanMaker 2021 for Windows
Topic: open worksheets of unknown count in same workbook
Replies: 4
Views: 142

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...
by Princy557
Sun Apr 05, 2020 12:04 am
Forum: BETA PlanMaker 2021 for Windows
Topic: worksheet - Copy to right freezes
Replies: 2
Views: 193

Re: worksheet - Copy to right freezes

Hi, Update: I have it working. I reinstalled it. As if by magic it's all working. I tried it dozens of times copy to right, left, start and end none of them would work. Also when this happened , if I tried to do the action again the program froze and I had to restart the computer. So please mark as ...
by Princy557
Thu Apr 02, 2020 5:23 am
Forum: BETA PlanMaker 2021 for Windows
Topic: worksheet - Copy to right freezes
Replies: 2
Views: 193

worksheet - Copy to right freezes

HI Couple of days ago I created a new project. Three worksheets. I did as I always do for the way I work, created a sheet which I call 'whatever Blank'. On this sheet I created the main layout for multiple repeat uses. When it's done I select the worksheet, copy to the right and hit enter. Now parts...
by Princy557
Sat Mar 21, 2020 12:10 pm
Forum: BETA SoftMaker Office 2021 for Windows (General)
Topic: Where is my license number
Replies: 2
Views: 264

Re: Where is my license number

Hi Martin-k
Yes it has worked today and all seems to be running. When I tried yesterday I got nothing back at all.
I possibly may have confused the system as I have another account from years ago.
Anyway, it's all running now.
Thanks for getting back to me.
Princy557

Go to advanced search