Combine 2 workbooks together with multiple worksheets

**dcnorman07** · 09-11-2008, 03:03 PM

Hi all,

I have been searching for ever now and can't seem to find what I am looking for...(maybe I am wording it wrong)

What I have to do is take Workbook 1 and copy all the data and paste it under all the data in Workbook 2... and do this for about 200 worksheets per workbook, all of them with the same titles.

So for example....

Take all of the rows with data in them starting with row 4, from Workbook 1, Worksheet 1 and paste them under all the rows with data in Workbook 2, Worksheet 1.

Then.... go to Worksheet 2, then Worksheet 3 and so on...

I program in Java, and know a little about VBA, but not nearly enough to get this hammered out... Any help would be greatly appreciated.

Thanks

**yawnzzzz** · 09-11-2008, 04:12 PM

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.

**dcnorman07** · 09-11-2008, 04:32 PM

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