I need a VBA script which will combine multiple worksheets into one. Each worksheet will have the same number of columns, A through N.
Each worksheet has first 7 lines/rows as headers which need not be copied over and over for the compiled sheet. Worksheets can have anywhere from 1 to 4000 lines/rows of data.
In addition, each worksheet has a dept number in cell A4. which needs to be copied over to column A of the compiled sheet
I have attached an example on how it should look, the top part is how the data presents itself in the initial report, boxed in is how I want it to look in a compiled sheet
Each worksheet has first 7 lines/rows as headers which need not be copied over and over for the compiled sheet. Worksheets can have anywhere from 1 to 4000 lines/rows of data.
In addition, each worksheet has a dept number in cell A4. which needs to be copied over to column A of the compiled sheet
I have attached an example on how it should look, the top part is how the data presents itself in the initial report, boxed in is how I want it to look in a compiled sheet