moving worksheets between workbooks


J

jim_epler

I have three workbooks that I'd like to consolidate into one workbook
with 3 sheets. Workbook #1 contains linked cell references in
workbooks #2 and #3. How can I move the worksheets from workbooks #2
and #3 into workbook #1 while maintaining the integrity of the linked
cell references?

Thanks,

-Jim
 
Ad

Advertisements

G

Guest

Hi Jim,

I don't now how this will affect the links, but you can move worksheets this
way
-Open all the workbooks invovled
-Right click on the tab of the sheet you want to move and choose move or
copy from the popup menu
-In the new dialog click on the dropdown to select the workbook you wan to
send to to then Ok

You might this with copies of the workbooks just in case it does affect the
links.

Mike
 

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

Top