Merge workbooks

[Guest]

Hello,
I would like to know if merging workbooks is what I need to do.

My boss has a workbook he has added columns and rows to. Occasionally
someone in the company will send him an updated workbook, but their updated
workbook does not have the added columns and rows to it. He would like me to
figure out if we can merge the two of them without messing up his added
columns and rows.
Is this possible? Or do we want to try something else? And if it is merging
workbooks we want, what is the easiest way?

 

[Pete_UK]

If by "merging" you mean you want to add the data from a newer
workbook to what you already have, then you will just need to insert
the relevant columns in the newer book and then copy/paste the data
across.

If, however, you mean that you want to affect the values that your
boss has in his file then you could probably do it using VLOOKUP - you
will need to provide more details of the layout of both files and what
you want to do with them, though, if you want more detailed help.

Pete