EXCEL

[marinosandria78]

Dear All,
I have multiple workbooks with several worksheets included on each workbook. I need to copy each worksheet from each workbook,merge them together and copy them to a new workbook. E.G. Workbook(1) with worksheet(1),worksheet(2),etc.
Workbook(2) with worksheet(1),worksheet(2),etc.
Copy From Workbook(1) worksheet(1) and From Workbook(2)
worksheet(1) to the new Workbook merge them together
and place them at worksheet(1) of the new workbook.
The same for the worksheets(2) and etc.

Can anyone help me?

Thanks
Marinos

 

[SkipVought]

hi,

This could be a VBA question that should be addressed in forum707, unless you are doing this in VB5 or VB6.

Skip,
[sub]
Just traded in my old subtlety...
for a NUANCE![/sub]

 

[TysonLPrice]

Writing a macro to generate the code is sometimes a good start. In the following link scroll down to the topic "How do I write code to … ? [a.k.a. recording macro's]".

http://www.vbforums.com/showthread.php?t=391665