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 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.