The Magic of Data Validation
Dynamic Data Validation… is a Game changer in Excel, at the basic level it controls what a user can enter or cannot enter in a cell. It also makes data entry easier and ensures the integrity of your worksheet by avoiding typing errors when users can simply select an option from a drop list.
However, in more advanced scenario drop lists can make a regular worksheet look as a dynamic dashboard.
In this article, we explore the full potential of drop lists by creating basic drop lists, diminishing drop lists and then we create dependent drop lists with 6 levels of dependency. We will learn about the extreme power of combining Drop lists with Dynamic arrays and touch the limit of what Data Validation can do.
I delivered this topic at the Global Excel Summit on July 22nd. 2020 at 6:00 PM (GMT-5 Eastern Standard Time US & Canada)
You can download the exercise File and follow along by clicking on the Green button
You can also read my step by step guide about data validation that maps to this tutorial, it’s a reference book for you to keep and is also available for you to download by clicking on the Orange button.
I would appreciate receiving your comments about this tutorial, blog and video in which I put a huge effort and a lot of time.