Dashboards

Reset Dependent Drop-down in Excel

Reset Dependent Drop-down in Excel (with a tiny bit of VBA) Learn how to reset a dependent drop-down list in Excel with a little bit of VBA. The problem we get with dependent data validation lists is that when you change the value

Excel Dependent Combo Box Solves an Annoying Problem

This Excel Dependent Combo Box Solves an Annoying Problem (you've probably had this) In this tutorial you'll learn a lot about combo box drop-down lists in Excel: 1. How to create a combo box drop-down list 2. How to create a dependent

First Excel Hash Challenge between 6 MVPs

What is #ExcelHash? It's the Iron Chef Tournament between 6 Excel MVP YouTubers. If you're serious about learning Excel, you've probably come across their videos: Mike Girvin from Excel is Fun; Bill Jelen from MrExcel; Mynda Treacy from MyOnlineTrainingHub; Jon Acampora from Excel Campus; Oz from

Expandable Conditional Drop Down Lists in Excel

Smart Dependent Drop-Down Lists in Excel: Expandable & Excluding Blank Cells In situations where the contents of a drop-down list are frequently changing, it's helpful to have a dynamic drop-down list that can automatically expand, as well as exclude any blank cells

Lookup on Pictures

Dynamic Picture Lookup in Excel Just 5 easy steps - No VBA How can you lookup different pictures based on the value of a cell? Just to give you a heads up. This is a VBA-free tutorial! We saw the dynamic picture

Excel Dependent Drop Down List with Tabular Data

Handle dynamic data validation lists that refer to parts of your table only  Excel Dependent Drop Down List with Tabular Data without Named Ranges   There are some cases where you need to create a dependent drop down list using a source