Is it merging workbooks that I want?

B

Bonnie

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?
 
B

Bernie Deitrick

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
 
Top