PDA

View Full Version : VBA Code to Merge Workbooks in a Folder



PRS25
05-30-2017, 05:37 PM
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