merge data from one workbook to another

beck · December 5th, 2005, 02:52 AM posted to microsoft.public.excel.newusers

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.

Barb Reinhardt · December 6th, 2005, 01:02 AM posted to microsoft.public.excel.newusers

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.

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
How do I mail merge to EMAIL from MS Word AND add a pdf attachment	Lily@Insight	Mailmerge	24	January 15th, 2007 09:33 PM
Protect Workbook vs Worksheet??	Dan B	Worksheet Functions	3	November 7th, 2005 09:02 PM
Help PLEASE! Not sure what answer is: Match? Index? Other?	baz	Worksheet Functions	7	September 3rd, 2005 03:47 PM
Mail merge error occurs when filtering Excel data source	Dave	Mailmerge	1	December 2nd, 2004 10:46 PM
SQL view of messed up action queries	Kendra	Running & Setting Up Queries	2	August 31st, 2004 09:53 PM