Best way to guarantee data consistency

[MotorJena]

Hi
I have a sheet with almost all the soccer teams in the world, which I did by webscrapling using selenium, the teams are separeted by its countries, columns represent each country

Now assume an user has to build a ranking based on some competition (assuming that the developer has done anything, the user only has to type the teams and the points), but the user has to search for the teams in the mentioned sheet to guarantee data consistency (for instance, he would write Internazionale, inter Milano; which it should not be allowed) What would be the best way? the user could write a team and by the means of a worksheet_change event it would trigger a message box and lead the user to search for the team by the means of a form or something; a combox on each cell (it would be to many since there are many seasons) in some way the user could select the country of the team to at least to lower the size of the combobox, or any other idea?

Sorry my bad english and Thanks!

 

[MotorJena]

Correcting:
* (assuming that the developer has done everything)

 

[RoryA]

Welcome to the MrExcel Message Board!

Cross-posting (posting the same question in more than one forum) is not against our rules, but the method of doing so is covered by #13 of the Forum Rules.

Be sure to follow & read the link at the end of the rule too!

Cross posted at:

Best way to guarantee data consistency, Help

Hi I have a sheet with almost all the soccer teams in the world, which I did by webscrap using selenium, the teams are separeted by its countries, columns represent each country Now assume an user has to build a ranking based on some competition (assuming that the developer has done the...

www.excelforum.com

There is no need to repeat the link(s) provided above but if you have posted the question at other places, please provide links to those as well.

If you do cross-post in the future and also provide links, then there shouldn’t be a problem.