-
VBA Code to Merge Workbooks in a Folder
Hi Experts –
There are so many different vba codes to merge sheets from different workbooks into one workbook. My requirement is a bit unique. I have 10 workbooks saved in a common folder. Each workbook contains 15 sheets with identical headers but different values underneath. I want to pull data from each tab into one summary tab. Ex – sheet1 from my 10 workbooks should be captured in one new sheet.
Can someone can provide a code that can automate this function, and edit it to start pulling all available data after row 3 of each sheet?
Regards,
Pat
Tags for this Thread
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules