Compare and Insert from Two Spreadsheets

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Boulder257 - 13 Jul 2006 17:23 GMT

Let's say I have two spreadsheets. Each has the name of employees from a
company, but spreadsheet B does not contain all of the names on
Spreadsheet A. I want Excel to look spreadsheet A and input any
information relating to an employee that is also listed in Spreadsheet
B. Is this possible?

Signature

Boulder257

Reply to this Message

Ryan.Chowdhury@gmail.com - 13 Jul 2006 21:08 GMT

Do you want a unique list of Employees that overlap A and B? Do you
want to pull employee data from an area adjacent to the names in A or B
or in a totally separate area?

In general, you want to take advantage of named ranges and vlookups,
but Excel can definitely handle references across files servers.

> Let's say I have two spreadsheets. Each has the name of employees from a
> company, but spreadsheet B does not contain all of the names on
[quoted text clipped - 7 lines]
> Boulder257's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=20053
> View this thread: http://www.excelforum.com/showthread.php?threadid=561169

Reply to this Message