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 "Move or Copy..."
in the pop-up menu, select the destination workbook (drop it down under "To
Book") and the rest is automatic. Pls note to check "create a copy" in case
you want to keep yr data/chart in the original worksheet also, otherwise it
just moves.
Good luck.
Br,
Henk

"Margarita" wrote:

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!

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

"HEK" wrote:

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 "Move or Copy..."
in the pop-up menu, select the destination workbook (drop it down under "To
Book") and the rest is automatic. Pls note to check "create a copy" in case
you want to keep yr data/chart in the original worksheet also, otherwise it
just moves.
Good luck.
Br,
Henk

"Margarita" wrote:

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:
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

"Margarita" wrote:

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

"HEK" wrote:

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 "Move or Copy..."
in the pop-up menu, select the destination workbook (drop it down under "To
Book") and the rest is automatic. Pls note to check "create a copy" in case
you want to keep yr data/chart in the original worksheet also, otherwise it
just moves.
Good luck.
Br,
Henk

"Margarita" wrote:

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!