The macro recorder is your friend. Try it and then post back with questions.

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"BRABUS" wrote in message
...

Ok I am sure this has been covered a million times but I am struggling
to find something that will help me so I appologise up front.

I am working with XL 2003 SP3 and have a spreadsheet (lets say its
called "ORIGINAL") that is open and running a macro. During this macro
I would like it to open another spreadsheet (lets say its called
"SECONDARY") and copy a worksheet called "Sheet1" and then paste it
back into the "ORIGINAL" spreadsheet.

I have tried various methods and get constantly changing results. Does
anyone have any very simple code PLEEEEEEEEEASE.




--
BRABUS