merge data from one workbook to another
 

I am trying to import data from one workbook to another, but need to do two
things in this process. I need to compare data and only insert what is
missing. IE in one column of one workbook there is a group of client ID's.
IN the other workbook there is a sales associate for that client. I would
like to merge these so that excel automatically reads the client id and
inserts a new column with the sales associate for that id.

merge data from one workbook to another
 

I'd use the VLOOKUP function.

"beck" wrote:

I am trying to import data from one workbook to another, but need to do two
things in this process. I need to compare data and only insert what is
missing. IE in one column of one workbook there is a group of client ID's.
IN the other workbook there is a sales associate for that client. I would
like to merge these so that excel automatically reads the client id and
inserts a new column with the sales associate for that id.