Presently I have multiple excel files in one folder, I need a vba code which does the below activity.
Open all the excel files one after the other in ascending order and paste the data in new workbook in a single sheet.
All files contain headers, but I want header to be copied and pasted only once and not every time multiple excel files are opened.
For example: Book A and Book B contains data from 1st row to 100th row (including header). I want data to be copied 1st row to 100th row (including header) of Book A and paste in Book Consolidated, copy data from 2nd row to 100th row (exclude header) in Book B and paste it in 101st row in Book Consolidated.
Let me know if you have any questions.
Any help is much appreciated.