Hi all
I have a folder with 20 workbooks. Each workbook has roughly 14 tabs. The tab naming is consistent across all workbooks, however some workbooks might not have all tabs (some have 12, 10,14 etc)
I would like a macros to merge all the workbooks into a single workbook, combining all the tabs with similar names into one tab with that name in the workbook, with the column headers being used once if possible.
Any help you can provide would be greatly appreciated
Dave
I have a folder with 20 workbooks. Each workbook has roughly 14 tabs. The tab naming is consistent across all workbooks, however some workbooks might not have all tabs (some have 12, 10,14 etc)
I would like a macros to merge all the workbooks into a single workbook, combining all the tabs with similar names into one tab with that name in the workbook, with the column headers being used once if possible.
Any help you can provide would be greatly appreciated
Dave