nightracer
Board Regular
- Joined
- May 17, 2004
- Messages
- 147
- Office Version
- 365
Hi
As per the title, I have multiple single sheet workbooks, and need to compile the data from each into one single sheet, taking the data in columns A-V.
All of the workbooks have the same column headers in row 1 and are in a single folder.
The number of rows can vary from 150 to 500+, so overall I am looking at 12,000+ rows.
Ideally it would happen in order, so pick all the data from Book1, then Book2 below that, then Book3 and so on.
The number of workbooks generated that need compiling can vary from 25 to 360.
Is this possible via either a macro or an add-in menu solution?
Any pointers appreciated.
As per the title, I have multiple single sheet workbooks, and need to compile the data from each into one single sheet, taking the data in columns A-V.
All of the workbooks have the same column headers in row 1 and are in a single folder.
The number of rows can vary from 150 to 500+, so overall I am looking at 12,000+ rows.
Ideally it would happen in order, so pick all the data from Book1, then Book2 below that, then Book3 and so on.
The number of workbooks generated that need compiling can vary from 25 to 360.
Is this possible via either a macro or an add-in menu solution?
Any pointers appreciated.