Hello code experts
I have here 25 sheets all with the name of E_Invoices + State Code with 1000's of rows of data. I am trying to combine all the data in one sheet in a new sheet named E_Invoices. The data of the first sheet to be copied to a new sheet and the rest of the sheets the data of which to be pasted below the last empty row in the new sheet. For your reference I have shared only 3 sheets so that I can upload it without any problem. The 25 sheets data starts from the 5th row and the new sheet data must begin at the 2nd row. The headings and columns count are same in all the sheets.
I have been able to copy the data of first sheet to the new sheet but to combine the data of the other sheets to the last empty row of the E_Invoices sheet, it is my first. I need your expertise to do this with the help of a code which I can in my already existing code.
Please note that I need to combine 25 sheets and not only 3 as in the sample data. Using a loop function or something I think it will be possible to check all sheets with the name E_Invoices + code.
Thank you in advance.
Bookmarks