Convert Employee Numbers to names in Excel

  • Thread starter Thread starter Gary M.
  • Start date Start date
G

Gary M.

Hi,
I have several Excel Spreadsheets with lists of employee numbers (ex. 12345,
12346, 12347 etc.) I would like to automatically convert those numbers to
names (ex. 12345 = Smith, John). is there some way to do this with a macro?
Any help would be appreciated. Thank you.

(e-mail address removed)
 
Assuming you have a sheet with employee numbers and names listed, check out
the VLOOKUP function.
 
Dennis, Thanks for the reply. I'm not sure if VLOOKUP will work. Basically
I'm scanning employee ID badges (ID #) into an excel spreadsheet for
attendance purposes. Each meeting may have different employees as well as be
in a different order. What I want to do is run a macro to read the employee #
and then "paste" their name behind it or in the next column.
 
Do you have a complete list of employee names and numbers in an excel
spreadsheet?
 
Back
Top