Copying Tabs in Excel

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

Guest

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?
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Changing Multiple Graph's Source Data 4
Copy Graph But change Data Sheet 1
Copying data from cells A1,B1,C1 on tab1 to tab2 1
Excel Move or Copy Stopped Working? 0
Excel 2003 memory usage 1
Macro: finding a cell on one worksheet and copying to another worksheet 0
Add/Subtract columns from tab to tab in same file 3
Copying Tab references 4

Back
Top