I am copying and pasting data and charts from one worksheet to another. I
then do a find and replace on the data to change one of my variables.
However, the charts do not update to the new worksheet, but rather keep the
previous worksheet data (ex. 1st worksheet is CFBG, new worksheet is MKTG.
Source data stays =CFBG!$B$1 when I want it to change to =MKTG!$B$1).
I have 10 more worksheets to go. Any ideas how I can quickly change the
source data from one worksheet to another? I tried the Find and Replace but
couldn't get it to work.
Also, Paste Special won't work.
Thanks

You have to copy the charts and data in one operation. If you copy a chart
separately, it maintains its link to the original data.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
http://PeltierTech.com
_______


"DaddyO" wrote in message
...
I am copying and pasting data and charts from one worksheet to another. I
then do a find and replace on the data to change one of my variables.
However, the charts do not update to the new worksheet, but rather keep
the
previous worksheet data (ex. 1st worksheet is CFBG, new worksheet is MKTG.
Source data stays =CFBG!$B$1 when I want it to change to =MKTG!$B$1).
I have 10 more worksheets to go. Any ideas how I can quickly change the
source data from one worksheet to another? I tried the Find and Replace
but
couldn't get it to work.
Also, Paste Special won't work.
Thanks