Copying Tabs in Excel

  • Thread starter Christopher Anderson
  • Start date
C

Christopher Anderson

I have two tabs in an excel worksheet. Tab A has data, Tab B has graphs from
the data in Tab A. When I copy and paste these two tabs into the same
workbook, I get Tab A (2) and Tab B (2). The problem is that the graphs in
Tab B (2) are still referencing the data in Tab B. I have to go in and
change the source data from Tab B to Tab B (2). Is there a way around this
procedure or do I have to go in and change the source data everytime I copy a
tab with graphs?

Thanks

Chris
 
D

Dave Peterson

If you select TabA and ctrl-click on TabB and copy them as a unit to the other
workbook, does that help?
 
Top