I use an Excel worksheet to keep track of employee hours and the productivity they accomplish but on any given day, I have different employees who work with different people so each day I have to enter up to 20 different names and I would love to be able to just start typing a name and have it fill in automatically. Is that an option in Excel? Any way I can make this process quicker would be great.
Excel VBA Course - From Beginner to Expert
200+ Video Lessons
50+ Hours of Video
200+ Excel Guides
Become a master of VBA and Macros in Excel and learn how to automate all of your tasks in Excel with this online course. (No VBA experience required.)
Using Autocomplete in Excel worksheet
0
Answers
0
The easiest way to do this would be to crate a list of the names in a named range on a dedicated worksheet. Format the column where you need to enter the names with a Data Validation dropdown. Look at the implementaiton in the attached workbook.
The data validation dropdown doesn't have auto-complete. For that you would have to use an ActiveX ComboBox. That takes a lot more effort, however,. Try the simple data validation first.
0
If you use this a lot, you might want to look into creating a UserForm for data entry; if you enter many pieces of similar information on a frequent basis, this will save you a lot of time.