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
TrowaD Posts 2921 Registration date Sunday September 12, 2010 Status Moderator Last seen December 27, 2022 - Aug 9, 2018 at 11:33 AM
Related:
- Open multiple Workbook and populate them
- Allow multiple downloads chrome - Guide
- How to delete multiple files at once - Guide
- Photoshop multiple selections - Guide
- Which key is used to make multiple line in a single cell - Guide
- Share multiple contacts android - Guide
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
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
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
Aug 7, 2018 at 12:55 PM
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...
Aug 9, 2018 at 11:33 AM
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