software

I need to copy a set of data AND the chart that I made from it to a specific
worksheet in another workbook... but when I try to just select it, copy it
and paste it in the ither worksheet, the source of the data remains on the
other workbook... is there a way of doing it without having to re-establish
all the links?? Please help!

Margarita:
You can copy an entire worksheet into a new workbook. Assuming yr data and
chart are in the same worksheet, right-click the tab where the name of the
sheet appears (somewhere near the bottom left side), select quot;Move or Copy...quot;
in the pop-up menu, select the destination workbook (drop it down under quot;To
Bookquot;) and the rest is automatic. Pls note to check quot;create a copyquot; in case
you want to keep yr data/chart in the original worksheet also, otherwise it
just moves.
Good luck.
Br,
Henk

quot;Margaritaquot; wrote:

gt; I need to copy a set of data AND the chart that I made from it to a specific
gt; worksheet in another workbook... but when I try to just select it, copy it
gt; and paste it in the ither worksheet, the source of the data remains on the
gt; other workbook... is there a way of doing it without having to re-establish
gt; all the links?? Please help!

Thanks Hek, but my problem really is that I need to consolidate a lot of
different graphs which are currently in different worksheets and workbooks
just into ONE worksheet, so I actually do need to copy just the graphs and
data, not the whole worksheet, is there a way to do that without needing to
re-establish links?
Thanks,
Margarita

quot;HEKquot; wrote:

gt; Margarita:
gt; You can copy an entire worksheet into a new workbook. Assuming yr data and
gt; chart are in the same worksheet, right-click the tab where the name of the
gt; sheet appears (somewhere near the bottom left side), select quot;Move or Copy...quot;
gt; in the pop-up menu, select the destination workbook (drop it down under quot;To
gt; Bookquot;) and the rest is automatic. Pls note to check quot;create a copyquot; in case
gt; you want to keep yr data/chart in the original worksheet also, otherwise it
gt; just moves.
gt; Good luck.
gt; Br,
gt; Henk
gt;
gt; quot;Margaritaquot; wrote:
gt;
gt; gt; I need to copy a set of data AND the chart that I made from it to a specific
gt; gt; worksheet in another workbook... but when I try to just select it, copy it
gt; gt; and paste it in the ither worksheet, the source of the data remains on the
gt; gt; other workbook... is there a way of doing it without having to re-establish
gt; gt; all the links?? Please help!

Margarita:
If you MOVE the data/chart instead of COPY them, Excel establishes new
links, using to the new cell references to. It doesnt matter whether u start
w/ the chart or w/ the data. In case u want to keep the original, first make
a workbook copy.
Hope this works for you.
br,
Henk

quot;Margaritaquot; wrote:

gt; Thanks Hek, but my problem really is that I need to consolidate a lot of
gt; different graphs which are currently in different worksheets and workbooks
gt; just into ONE worksheet, so I actually do need to copy just the graphs and
gt; data, not the whole worksheet, is there a way to do that without needing to
gt; re-establish links?
gt; Thanks,
gt; Margarita
gt;
gt; quot;HEKquot; wrote:
gt;
gt; gt; Margarita:
gt; gt; You can copy an entire worksheet into a new workbook. Assuming yr data and
gt; gt; chart are in the same worksheet, right-click the tab where the name of the
gt; gt; sheet appears (somewhere near the bottom left side), select quot;Move or Copy...quot;
gt; gt; in the pop-up menu, select the destination workbook (drop it down under quot;To
gt; gt; Bookquot;) and the rest is automatic. Pls note to check quot;create a copyquot; in case
gt; gt; you want to keep yr data/chart in the original worksheet also, otherwise it
gt; gt; just moves.
gt; gt; Good luck.
gt; gt; Br,
gt; gt; Henk
gt; gt;
gt; gt; quot;Margaritaquot; wrote:
gt; gt;
gt; gt; gt; I need to copy a set of data AND the chart that I made from it to a specific
gt; gt; gt; worksheet in another workbook... but when I try to just select it, copy it
gt; gt; gt; and paste it in the ither worksheet, the source of the data remains on the
gt; gt; gt; other workbook... is there a way of doing it without having to re-establish
gt; gt; gt; all the links?? Please help!