Macro to copy and paste information into new sheets.

[Barking_Mad]

Hi,

The problem i have is this. I have button operated macros on the same sheet (MODULE) which allows the user to:

a) Create a direct copy of the existing MODULE sheet and open it into a new sheet.

b) Copy a named range (peoples names) from the MODULE sheet into another pre-created sheet called ARCHIVE.

Also, on the pre-created sheet called ARCHIVE, I have a macro that allows the user to:

a) Create a direct copy of the ARCHIVE sheet and open it into a new sheet.

All these work fine. The issue arises once the user tries to copy names from a newly created MODULE sheet into a newly created ARCHIVE sheet as it copies the information back into the original ARCHIVE and not into the new one. How can I make sure it copies the names into the new sheet rather than the old one?

I'd also say i created these by simply recording the actions rather than coding them, which might be part of the problem....

Hope this makes some sort of sense...

Thanks