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

[Barking_Mad]

This is the current code

Sub CopyNames()
'
' CopyNames Macro
' copies names over to archive
'
' Keyboard Shortcut: Ctrl+n
'
Application.Goto Reference:="namesrange"
Selection.Copy
Sheets("Archive | ").Select
Range("A13").Select
Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks _
:=False, Transpose:=False
End Sub

[DonkeyOte]

To best describe or illustrate your problem you would be better off attaching a dummy workbook, the workbook should contain the same structure and some dummy data of the same type as the type you have in your real workbook - so, if a cell contains numbers & letters in this format abc-123 then that should be reflected in the dummy workbook.

If needed supply a before and after sheet in the workbook so the person helping you can see what you are trying to achieve.

In this instance I suspect we need the file with all VBA present

[royUK]

Also, please use Code Tags not Quote tags around your code.