On one sheet I will be entering employee names. On another sheet, a data sheet I will have a list of their names along with their employee numbers.
Instead of looking up a employee number each time, I was trying to see if it was possible for it to be grabbed from this data sheet and populated into a cell next to the name.
Attached is a sample sheet.
Thanks for any help.
Nick
Bookmarks