I have a user who uses an Excel Workbook to track the time sheets of her employees. What she wants to do is have a list of the employees' names and have a number attached to them so that all she needs to do in one of the columns on her spreadsheet is type in the number and have the employee name appear instead of the number. Is this possible in Excel?
Thanks in advance!
This conversation is currently closed to new comments.
Investigate HLookup() and VLookup() functions. You can have a lookup table with numbers and names on another sheet, and use this function to return the name that matches the number. The number and the employee name will be in different columns, but does this really matter?
I am going to assume the timesheet for each employee is a seperate sheet in the workbook.
You could set up a list of employees with a hyperlink that takes you directly to that employee's sheet.
This link reference will work if all the time sheets are on the same sheet as well.
If your familiar with VBA you could make a front end sheet that has the input box for the employee record and then have the VBA code search for the correct location the sheet for that person.
If you're asking for technical help, please be sure to include all your system info, including operating system, model number, and any other specifics related to the problem. Also please exercise your best judgment when posting in the forums--revealing personal information such as your e-mail address, telephone number, and address is not recommended.
Excel Input Mask
Thanks in advance!