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
 
Back
Top