Open multiple Workbook and populate them

Closed
manu9121 Posts 2 Registration date Tuesday August 7, 2018 Status Member Last seen August 7, 2018 - Aug 7, 2018 at 11:54 AM
TrowaD Posts 2921 Registration date Sunday September 12, 2010 Status Moderator Last seen December 27, 2022 - Aug 9, 2018 at 11:33 AM
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 response

TrowaD Posts 2921 Registration date Sunday September 12, 2010 Status Moderator Last seen December 27, 2022 552
Aug 7, 2018 at 11:59 AM
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
manu9121 Posts 2 Registration date Tuesday August 7, 2018 Status Member Last seen August 7, 2018
Aug 7, 2018 at 12:55 PM
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...
0
TrowaD Posts 2921 Registration date Sunday September 12, 2010 Status Moderator Last seen December 27, 2022 552
Aug 9, 2018 at 11:33 AM
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
0