flwoOrlando
New Member
- Joined
- Nov 18, 2015
- Messages
- 4
I am trying to write/find VBA code that can consolidate multiple workbooks that have multiple sheets into 1 larger file.
Each file/workbook is called by the month it was generated in.
Each sheet (and there are 12) are called in numberical order: 1, 2, 3, 4.... 12.
Each sheet has different headers, but the headers are the same for each sheet.
I am able to borrow vbs code that takes all 12 files, and merges each tab into the workbook, so i end up with a sheet 1 and sheet 1(11), etc...
I want 1 file with 12 sheets, with all the data from the 12 sheet1's in 1 sheet.
Each file/workbook is called by the month it was generated in.
Each sheet (and there are 12) are called in numberical order: 1, 2, 3, 4.... 12.
Each sheet has different headers, but the headers are the same for each sheet.
I am able to borrow vbs code that takes all 12 files, and merges each tab into the workbook, so i end up with a sheet 1 and sheet 1(11), etc...
I want 1 file with 12 sheets, with all the data from the 12 sheet1's in 1 sheet.
