Is it merging workbooks that I want?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

My boss has a workbook that he has added columns and rows to. He gets sent an
updated version every couple of months from someone else. But the updated
version does not have his added columns and rows. Can we merge the workbooks
and be able to keep his added columns and rows to his workbook?
 
Bonnie,

Not automatically. You could open both, set up links to the new values, copy the formulas down to
create enough links, then change the formulas to values.

HTH,
Bernie
MS Excel MVP
 

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

Similar Threads

Merge workbooks 1
Sharing workbooks limitations - Merged Cells 12
correlating and summing data from multiple spreadsheets 1
Import multiple workbooks to current workbook in specified row number 0
Excel lookup across entire workbook 1
Copy a sheet contained formulas from one workbook to another and remove file links 3
Outlook Lost Pst Files 1
Merging multiple workbooks into one master workbook 2

Back
Top