Try using VLookUp function please

"Curtis" wrote in message
...
I am not sure if this question belongs to this discussion group but here
it is

I have one sheet that contains all employee information
I would like to be able to type any employee ID in a seperate sheet in the
same workbook an pull all the related information listed in sheet 1

thanks

ce