hello,
I am rather new to excel programing and have a simple question. I
am hoping that someone can set me in the right direction. I have a
drop down list and the ListFillRange is set to Sheet2!$A$2:$A$5. Is
there an easy way to store a different value for each item in the
listfillrange? For example, if an item in the drop down is displayed
as Bob Smith, is there a way to store an employee number with Bob Smith
in the drop down? I hope that this is clear enough. I want to do this
so that I can use the employee number in another cell.

Thanks,
Billy