Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Graphs reference data in old worksheet
I have a worksheet with 2 tabs labelled "Model" and "Graphs". The
"Graphs" sheet has many plots which reference the data on the "Model" sheet. Now I make copies of both these sheets in the same workbook. Let us call them "Model2" and "Graphs2". The problem is that the plots on "Graphs2" sheet point to the data on the "Model" sheet and not the "Model2" sheet. Is there a "global" command or VB routine I can use so that all the plots on "Graphs2" point to the data on "Model2" sheet rather than the data on "Model" sheet? I have noticed the same problem when I make a copy of a graph from another workbook. Any help will save a lot of re-editing. Thanks. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Macro question | Excel Worksheet Functions | |||
Losing reference when deleting worksheet | Excel Worksheet Functions | |||
How do I reference data from one worksheet to another using combob | New Users to Excel | |||
Help PLEASE! Not sure what answer is: Match? Index? Other? | Excel Worksheet Functions | |||
Macro to search for and display data in another worksheet | Excel Worksheet Functions |