Hello - I have a user that has a lot of data entry to manually enter. I want the user to be forced to select from roughly 2,000 different answers. I am having a tough time thinking of how to do this so that the user can type a few letters of the data, and have excel show them the various entries that are available to select from. I'm imagining a sort of autofill meets data validation?
For example, if the user started typing "sweater", I'd like them to select from the following list of sweaters (from the broader list of 2,000 different answers). Then they could just select from a drop down list of the appropriate sweater they desire.
Infant's Sweater
Toddler's Sweater: Cardigan
Toddler's Sweater: Pullover
Toddler's Sweater: Vest
Boy's Sweater: Cardigan
Boy's Sweater: Pullover
Boy's Sweater: Vest
Girl's Sweater: Cardigan
Girl's Sweater: Pullover
Girl's Sweater: Vest
Men's Sweater: Cardigan
Men's Sweater: Pullover
Men's Sweater: Vest
Women's Sweater: Pullover
Women's Sweater: Vest
Maternity Sweater: Cardigan
Maternity Sweater: Pullover
Maternity Sweater: Vest
Thoughts?
For example, if the user started typing "sweater", I'd like them to select from the following list of sweaters (from the broader list of 2,000 different answers). Then they could just select from a drop down list of the appropriate sweater they desire.
Infant's Sweater
Toddler's Sweater: Cardigan
Toddler's Sweater: Pullover
Toddler's Sweater: Vest
Boy's Sweater: Cardigan
Boy's Sweater: Pullover
Boy's Sweater: Vest
Girl's Sweater: Cardigan
Girl's Sweater: Pullover
Girl's Sweater: Vest
Men's Sweater: Cardigan
Men's Sweater: Pullover
Men's Sweater: Vest
Women's Sweater: Pullover
Women's Sweater: Vest
Maternity Sweater: Cardigan
Maternity Sweater: Pullover
Maternity Sweater: Vest
Thoughts?