Macro sheet naming and referencing

Hi guys,
new enough to macro's. having trouble writing a macro for copying a sheet.
Data is entered into the data sheet and each month a new sheet with graph is produced by the macro with the option of naming it.

I can't figure out how to have the source data for each new sheet/chart reference the data in the data sheet without the previous charts source data changing as a result. I essentially need to create a new chart with frozen data and be able to name the sheet. Any suggestions greatly appreciated.

Try with this macro:

    Sheets("Graph1").Copy After:=Sheets(Sheets.Count)
    ActiveSheet.Name = "Graph1 new"

where "Graph1" is the name of the window with your graph to copy.

I hope it's what you need.

Regards,
Antonio

Originally Posted by antoka05

Try with this macro:

    Sheets("Graph1").Copy After:=Sheets(Sheets.Count)
    ActiveSheet.Name = "Graph1 new"

where "Graph1" is the name of the window with your graph to copy.

I hope it's what you need.

Regards,
Antonio

Hey antoka thanks for the help however it doesn't seem to be working for me. When I used the above it just copied over my data sheet page and renamed it as graph1 new.#
I have a data sheet and a graph sheet. Each time I use the macro I want to make a new graph sheet using the information from the data sheet so at the end of the year there are 12 graphs, however the information in each graph most be frozen to the data at the time it was created and not continually reference the changing data on the data sheet.
It might be a bit confusing.
Thanks again