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 Contributor 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

Open multiple Workbook and populate them
How to open multiple media player windows - Guide
How to make multiple selections in photoshop - Guide
How to rotate multiple pictures at once windows 10 - Guide
Multiple download chrome - Guide
How to put multiple watermarks on a word document - Guide

1 response

Answer 1 / 1

TrowaD Posts 2921 Registration date Sunday September 12, 2010 Status Contributor Last seen December 27, 2022 555
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...

TrowaD Posts 2921 Registration date Sunday September 12, 2010 Status Contributor Last seen December 27, 2022 555
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

Similar discussions

How to create two WhatsApp accounts on a Windows PC?

Cannot download multiple files at once in WhatsApp Web

Can’t Log into Instagram from Multiple Devices

Create Multiple Workbooks With Template At Once

Excel - IF function with multiple words

Similar discussions

Subscribe To Our Newsletter!