Compare and Insert from Two Spreadsheets

B

Boulder257

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

Ryan.Chowdhury

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.
 
Top