Hello,
I have a project that right now requires a lot of copying and pasting of similar data sheets into one master sheet. When my data is exported from our accounting software, each “lot” is exported onto a separate sheet. I may have up to 100 sheets in one workbook.
The data exports into Excel in a very predictable format with the columns and data always aligning (data range is always between A:H for example). The trick is the number of rows will always change with each “lot”.
I would like to get a macro that will find the range in each sheet and copy the data onto a “master” sheet, then go to the next sheet, find the full range copy that data and then paste to the master, below the previous data. It would continue to do this until it has copied it from all sheets. I would put the Master sheet on the left and then have the macro move left to right looking in each next sheet.
For example of the output, See the attached workbook and the “Master” sheet.
The copy and paste does not have to be pretty as I can clean the data later. But all the data on one sheet, with the columns lined up is my goal.
Any feedback helps. Thank you in advance.
Bookmarks