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 Removed)

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.
>
> (E-Mail Removed)

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.
> >
> > (E-Mail Removed)

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

Dan,

Yes.

"dan dungan" wrote:

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

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

Alright!

Sorry, for not getting back sooner.