Open multiple Workbook and populate them [Closed]

Report
Posts
2
Registration date
Tuesday August 7, 2018
Status
Member
Last seen
August 7, 2018
-
Posts
2693
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
January 18, 2021
-
Hi,

I've been working and looking for a solution/code for a while but couldn't find anything that would fully work.

1. 'Name details.xltx' is the template to be used for the new workbooks
2. 'Input REF.xlsx' is the master file with specific details for each Name
3. There should be as many new workbooks as Name in 'Input REF' (12 in the example)
4. Each spreadsheet (3) of each new workbook shall be pre-populated with data included in 'Input REF'

Both files are here:
https://www.dropbox.com/sh/p0iu26223zg9uo1/AACl4Pd_aJRetf8HSDKticyia?dl=0

Would really appreciate if anyone can help

1 reply

Posts
2693
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
January 18, 2021
455
Hi Manu,

This looks very similar to a query I just answered. Have a look and let me know if you need additional assistance.

https://ccm.net/forum/affich-1055989-create-workbooks-from-a-list

Best regards,
Trowa
Posts
2
Registration date
Tuesday August 7, 2018
Status
Member
Last seen
August 7, 2018

Thanks very much for your answer.
Indeed it looks similar. Since my template has several tabs I would definitely need 2 files for both template and input data. And then create a new workbook instead of adding spreadsheets. As you may guess I'm far from being a VBA expert (though i can read it and understand it) and i wouldn't know how to manage this...
Posts
2693
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
January 18, 2021
455
Hi Manu,

I can understand that.

After taking a look at your files, I wonder what to do with the "Study" sheet of your template file.
You have multiple "Long" and "High" values, which the "All Fluke" sheet has room for, but the "Study" only has 1 location ...
What data would you like to populate on the "Study" sheet?

Best regards,
Trowa

Subscribe To Our Newsletter!

The Best of CCM in Your Inbox

Subscribe To Our Newsletter!