Hello,
I’m a new user of Excel Macros but your posts were very helpful in teaching me many things
I’ve created macros to extract data from multiple files into tables on multiple sheets. Now I have 4 sheets each having a table from A:D, I need to summarize the data into one sheet “Summary”, copy row 2 till the last filled row from the table on sheet 1, paste them in the table on the “Summary” sheet. Then, copy row 2 till the last filled row from the table on sheet 2, paste them in the next available row in the table on the “Summary” sheet, and so on…
It is important for me not to specify the range of the rows I want to copy since data are being increased and changed each time on the sheets.
You could find the file attached if needed...
I would really appreciate it if anyone could help me doing this, and thanks in advance![]()
Bookmarks