|
Pulling relative information from a seperate workbook
I've been creating a series of workbooks that pull information from one another to make reporting in our organization easier, but I've run into an issue that I can't quite figure out how to solve.
I prefer to use spreadsheet formulas, as my programming isn't that great, but If I have to use Basic, I will. The ultimate goal is as follows:
Workbook 1 has a list of employees (WB 1, Column A) and their employee numbers (WB 1,Column B). Workbook 2 has the same list of employees (WB 2, Column A), but in a different (and what will unavoidably be random) order. Now, the trick I'd like to pull is to have Workbook 2 reference it's own list of employees (WB 2, Column A) and fill the employee numbers into a new column (say, WB 2, Column B) to match the employee name.
To further clarify, Workbook 1 may look like this:
A B
Joe Smith #132
John Johnson #654
Eric Erickson #278
Steve Stevenson #236
And Workbook 2 may contain the same names, but in a different order:
A B
John Johnson #
Steve Stevenson #
Joe Smith #
Eric Erickson #
Now, what's the best way to go about populating column B in the second workbook with the appropriate numbers? Keep in mind, this is a process that needs to be repeated every week, so if it could happen automatically through spreadsheet formulas, that would be the best. Thanks to anyone who can help me out!
|