Join or sign in Register for your free TechRepublic membership or if you are already a member, sign in using your preferred method below. Use Your Email Use FacebookUse Linkedin

Excel Input Mask

Locked

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!

Topic

Clarifications

In reply to Excel Input Mask

Clarifications

Look up name from number

In reply to Excel Input Mask

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?

Well…

In reply to Excel Input Mask

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.

[Author]

Replies