Auto correct name spelling from a reference list

[AhmedAbdelhai]

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

 

[Akuini]

I suggest you use a searchable combobox instead of data validation.
You can find an example in this thread:

https://www.mrexcel.com/forum/excel-questions/1089693-data-entry-force-selection.html

 

[AhmedAbdelhai]

Works Perfectly!

Thank you so much!

I suggest you use a searchable combobox instead of data validation.
You can find an example in this thread:

https://www.mrexcel.com/forum/excel-questions/1089693-data-entry-force-selection.html

 

[AhmedAbdelhai]

I am just now having an issue saving the file.

I saved it as Macro-Enabled excel sheet.

But every time I save it I get the errors below.

http://s000.tinyupload.com/?file_id=38643626855711116238

http://s000.tinyupload.com/?file_id=00137257017524183376

can i get rid of this?

Sorry if the question is silly, I'm not that expert with excel..hehe

 

[Akuini]

I'm not sure why that happened.
But maybe this could help:
https://answers.microsoft.com/en-us...-include/fae98705-d078-4fc5-843a-908dda5be559

 

[AhmedAbdelhai]

Great
Got rid of one error
The external data error is still there
Threads online says its because of the pivot table
Anyways, this will do
Thank you very much!!

 

[Akuini]

You're welcome, glad to help, & thanks for the feedback.