Thread: Combine 2 workbooks together with multiple worksheets

It would help if you posted an example workbook.

Also, how many workbooks are you copying?

There would be two approaches I would choose from. Both would have a button on the 'main' workbook.

In scenario 1, you'd have a field next to the button asking for a workbook name. When the button's pressed, it would then grab all of the information from that workbook and past it into the main workbook.

In scenario 2, you would have all of the workbooks (except for the main) in one folder. When the button is pressed, it cycles through each workbook in that folder and pastes the data into the main workbook.

I am not able to upload them because the smallest workbook I have is 2,033 KB, and that's without any data.

I am only combining 2 workbooks, but will do it multiple times for different people. Each person has 2 workbooks and there are a total of 8 people, so I will do the merge 8 times.

I'll try to explain it a little better for now, until I find a way to post the spreadsheets.

*********************
wbA = workbook A
wbB = workbook B

wsAll = worksheet All
wsTest = worksheet Test
*********************
I need all of the data from wbA, wsAll, rows 4 to the end copied and pasted under all the data in wbB, wsAll.

Then, all of the data from wbA, wsTest, rows 4 to the end copied and pasted under the data in wbB, wsTest.

and so on....

There are about 200 ws I have to do this to for each person.

I was kinda hoping that I could manipulate a vba script to start from the first ws and go to the end and just copy and paste all the data starting with row 4 into a different workbook.

I will post a link or something to the files as soon as I can....might not be able to until the morning though...

Thank you for attempting to help