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.

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.

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.

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