using data from unknown quantity of worksheets

Post Reply
User avatar
Princy557
Posts: 192
Joined: Wed May 18, 2011 10:32 am

using data from unknown quantity of worksheets

Post by Princy557 »

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: 3088
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 »

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”