Convert Employee Numbers to names in Excel
 

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.

Convert Employee Numbers to names in Excel
 

Assuming you have a sheet with employee numbers and names listed, check out
the VLOOKUP function.

"Gary M." wrote:

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.

Convert Employee Numbers to names in Excel
 

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.

"Dennis" wrote:

Assuming you have a sheet with employee numbers and names listed, check out
the VLOOKUP function.

"Gary M." wrote:

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.

Convert Employee Numbers to names in Excel
 

Do you have a complete list of employee names and numbers in an excel
spreadsheet?

Convert Employee Numbers to names in Excel
 

Dan,

Yes.

"dan dungan" wrote:

Do you have a complete list of employee names and numbers in an excel
spreadsheet?

Convert Employee Numbers to names in Excel
 

I figured it out! Thanks for the info!!!

"dan dungan" wrote:

Do you have a complete list of employee names and numbers in an excel
spreadsheet?

Convert Employee Numbers to names in Excel
 

Alright!

Sorry, for not getting back sooner.