Excel Unplugged

Category Archives: Data Validation

Creating a dynamic Dropdown List with Data Validation from another workbook with a little help from Power Query

Probably the longest title of all times, but it leads to something great. First let’s explain Power Query. Power Query is an AddInn for Excel and part of ...

Creating a Data Validation dropdown list from another Workbook

Can you create a Data Validation Dropdown list that uses data from another workbook as a source? This question has been proposed to me continuously since I published ...

Dependent Data Validation dropdown lists

Our goal here, is to create a dropdown list by using Data Validation, where the contents of the list will be determined by another Data Validation Dropdown list. ...

Taking the Data Validation Dropdown list to the next level

Creating a dependent or linked Dropdown list In this article I will show you how to create dependent Dropdown lists using Data Validation and an Excel function ...