This is a demonstration of what’s possible with Excel’s data validation.
Too often spreadsheets have no layer of protection so, the doors are open wide for crap data to enter our datasets. We’ve got to stop being naughty and close those doors
Here, I show 3 spreadsheets and demonstrate various protective methods:
dependent dropdown lists, protected cells, protected sheets, cells that can only accept integers between 1 and 12.
I don’t go into the how-to detail. The goal here is to show the uninitiated what can be done. There are plenty of how-to tutorials around the internet. Sometimes we just don’t know what’s possible..
You can find me at: http:DataScopic.net