Copying Tabs in Excel
 

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

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

Christopher Anderson wrote:

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

--

Dave Peterson