AhmedAbdelhai
New Member
- Joined
- Jun 5, 2018
- Messages
- 22
Hii,
I am trying to create a sheet that would track samples distribution to customers.
In the attached sheet under the Tracking Sheet tab I've set the "HCP" column to be a drop down menu to avoid miss spelling names.
I want to avoid miss spelling names so the pivot table would be accurate.
The thing is, trying to find the name from the drop down list is time consuming.
I have found some tutorials to add a search bar to the drop down menu but it requires VBA which I know nothing about or the "Filter" function which is not yet in my excel 2016.
Is there anyway I could set the HCP cells to auto correct the names inserted using the drop down list as a reference?
http://s000.tinyupload.com/?file_id=31511500431783584627
Thank you
I am trying to create a sheet that would track samples distribution to customers.
In the attached sheet under the Tracking Sheet tab I've set the "HCP" column to be a drop down menu to avoid miss spelling names.
I want to avoid miss spelling names so the pivot table would be accurate.
The thing is, trying to find the name from the drop down list is time consuming.

I have found some tutorials to add a search bar to the drop down menu but it requires VBA which I know nothing about or the "Filter" function which is not yet in my excel 2016.
Is there anyway I could set the HCP cells to auto correct the names inserted using the drop down list as a reference?

http://s000.tinyupload.com/?file_id=31511500431783584627
Thank you