I am trying to generate a detailed pivot table from multiple worksheets as I explained in in my other thread.
However, I realized another solution (albeit a less elegant one) was to create a macro that simply copied and pasted the data from the different worksheets into one worksheet, and then I could create the pivot table from that sheet.
The columns will the be same across all the sheets. However, the number of rows will vary, so would it be possible for the macro to copy as far down as data was entered (ie if I have data in columns A-F, just copy everything in A-F)? Or would this process be slow and would it be smarter to have the macro copy a set, say, columns A-F down to row 100 and hope that I won't have more than 99 entries?
Also, if it is possible for the macro to copy all the columns, how would I make it skip the first row (the headers), since of course I don't want those being counted as data points?
Attached an example to show what I want.
ExampleMacro.xlsx
Bookmarks