using data from unknown quantity of worksheets

Questions and answers about PlanMaker 2018 for Windows
Post Reply
User avatar
Posts: 189
Joined: Wed May 18, 2011 10:32 am

using data from unknown quantity of worksheets

Post by Princy557 » Mon May 06, 2019 5:53 pm

Sorry it's me again.
I designed an invoice system for my son some time ago. As expected there are rather a lot and I now wish I had designed it differently. Water under bridge, far too many to change now.
System allows me to create a new invoice as required, customer databases are available and all information from them is used as required.
My problem is when a new invoice was created it get a name something like... 20190223. I have quite a f ew of these worksheets.
Is it possible for me to look in a folder, find all the sheets for 2018 or 2019, extract data from each sheet that starts with 2018 or 2019 and to place that information in another sheet called for example Totals?
If possible how and examples would be helpfull too.


SoftMaker Team
SoftMaker Team
Posts: 3047
Joined: Fri Nov 21, 2003 4:57 pm
Location: Nürnberg, Germany

Re: using data from unknown quantity of worksheets

Post by martin-k » Wed May 08, 2019 8:58 pm

You would need to write a script in BasicMaker to do that.
Martin Kotulla
SoftMaker Software GmbH

Post Reply

Return to “PlanMaker 2018 for Windows”