Creating multiple sheets for every row data/ Excel solution to Word's mailing list?
Hello everyone!
I have a question I've been trying to find a solution to for a while now.
I work in a construction company where we have many template contracts to prepare and print for various subjects with their respected info (address, contact person, type of work, sum etc.)
Once I discovered I could connect my access or excel database of clients to Word's mailing list where I select fields in the contract template it made my life so much easier.
Now, I have a situation where I need to make multiple bills of quantities based on a template where the data (headings info, type of works, quantity, price) would be connected to a table/database with all the rows containing BOQ info.
Basically, just like the mailing list in Word just this time I don't need .doc files I need excel sheets.
So far I understood I have to make a sheet template that would be created with a VBA Macro command, but I didn't find anywhere how to make multiple sheets based on each row from a certain table/database.
Any help to get me started would be much appreciated.
Thanks to everyone in advance!
