using data from unknown quantity of worksheets

Post your questions, bug reports and suggestions here for PlanMaker 2018 for Windows.

Moderator: SoftMaker Team

Post Reply
User avatar
Princy557
Posts: 151
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

HI
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.
SO
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.
Regards

Princy557

martin-k
SoftMaker Team
SoftMaker Team
Posts: 2884
Joined: Fri Nov 21, 2003 4:57 pm
Location: Nürnberg, Germany
Contact:

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”