Combine specified worksheets different workbooks with same data

[arrongraham]

Hi,

I required too combine specified worksheets from different workbooks, and only from a certain sheet within the workbooks (the sheets are called the same thing if this helps or not).

Does anyone know a marco which make this possible? I can combine worksheets from the same workbook just not different workbooks.

Thanks

Arron

[millz]

Post the working code that you current have? And how do you want to choose the "other" workbook(s)? A file selection dialog? or prefixed file name?

[arrongraham]

I have just reallised that I have been confusing workbooks with worksheets. What I require is to combine worksheets from different workbooks.

The other workbooks will always remain the same so can it be built into the code? The code bellow will combine specified worksheets within the same workbook. Can it be altered to combine sheets from separt workbooks. If it helps the sheets are called the same thing.

Please Login or Register  to view this content.

[millz]

Try this:

Please Login or Register  to view this content.

You can move that chunk to a whole new Sub instead if you want, but remember the Dim's

[arrongraham]

I get an error at the 'For Each ws In Sheets(Array("S1", "S2"))' line.

Say I have books called test1, test2 and test3 which are too be copied from and into book called Master.

From the test1, test2 and test3 books I requires too combine sheets called comb on all the sheets into sheet called the same thing on the Master book.

does this make sense?

[millz]

So open the Master workbook, and leave everything else closed. Change Workbooks.Open("C:\....\filename.xlsx") to one of the other books, test1, or test2, etc. Now run the code on Master, do you still get any error?

if yes, try changing For Each ws In Sheets(Array("S1", "S2")) to

Please Login or Register  to view this content.