Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
I have 2 workbooks with linked information how do I merge them
I have two workbooks that are linked with data. I would like to take the
sheet that is linked from one workbook and insert into into the other workbook so that only one workbook is required with the sheet still being linked to the other sheets in the second workbook. Hope this is clear. Thanking you. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
I have 2 workbooks with linked information how do I merge them
Try this on spare copies ..
With both books open .. Right click on the sheet tab Move or Copy .. Select the other book from the "To book:" dropdown Position as desired OK -- Max Singapore http://savefile.com/projects/236895 xdemechanik --- "Eqa" wrote: I have two workbooks that are linked with data. I would like to take the sheet that is linked from one workbook and insert into into the other workbook so that only one workbook is required with the sheet still being linked to the other sheets in the second workbook. Hope this is clear. Thanking you. |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
I have 2 workbooks with linked information how do I merge them
That is great . Thanks for that Max.
Regards Eqa "Max" wrote: Try this on spare copies .. With both books open .. Right click on the sheet tab Move or Copy .. Select the other book from the "To book:" dropdown Position as desired OK -- Max Singapore http://savefile.com/projects/236895 xdemechanik --- "Eqa" wrote: I have two workbooks that are linked with data. I would like to take the sheet that is linked from one workbook and insert into into the other workbook so that only one workbook is required with the sheet still being linked to the other sheets in the second workbook. Hope this is clear. Thanking you. |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
I have 2 workbooks with linked information how do I merge them
Pleasure`, Eqa.
-- Max Singapore http://savefile.com/projects/236895 xdemechanik --- "Eqa" wrote in message ... That is great . Thanks for that Max. Regards Eqa |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
linked workbooks | Excel Discussion (Misc queries) | |||
3 workbooks linked | Excel Discussion (Misc queries) | |||
name changes to linked workbooks | Excel Discussion (Misc queries) | |||
Ref Linked Workbooks | Excel Worksheet Functions | |||
Display references to linked information | Excel Worksheet Functions |