Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Convert Employee Numbers to names in Excel
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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. |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
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. |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Convert Employee Numbers to names in Excel
Do you have a complete list of employee names and numbers in an excel
spreadsheet? |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
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? |
#6
Posted to microsoft.public.excel.programming
|
|||
|
|||
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? |
#7
Posted to microsoft.public.excel.programming
|
|||
|
|||
Convert Employee Numbers to names in Excel
Alright!
Sorry, for not getting back sooner. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
1-52 pages, 8,000 employee numbers | Excel Discussion (Misc queries) | |||
Search for Employee Names | Excel Worksheet Functions | |||
Compare & align 2 cols of Employee Names in sorted alpha order withVBA | Excel Discussion (Misc queries) | |||
Employee Names in Capital Letters | Excel Discussion (Misc queries) | |||
Totals sheet - deal with employee names | Excel Worksheet Functions |