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