???Replicate a sheet but chart still link to original sheet

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a chart with named range in Sheet1.

When I copy Sheet1 as Sheet2, the source data in the chart of Sheet2 is
still linking to Sheet1.

How can I make the source data link to sheet2 automatically. As I have to
replicate sheet1 into 10 different sheets, the automation will help a lot.

Would appreciate advice
 
Back
Top