Do Magic with Excel Drop Lists …Dynamic Dependent Diminishing

In this project I show you how wow your boss, colleagues and clients by creating Dynamic Dependent Diminishing drop lists.

At the Basic Level, using drop lists in your worksheet makes entering data an easy process avoiding errors and adding interactivity to the project.

Creating dependent drop lists multiplies the usefulness by allowing the contents of a second drop list to change based upon your selection from the first list.

However, if you are Only allowed to select an option for a specific number of times, then it will be helpful to have that option removed from the drop list when we reach the set number of times.

So let’s explore the work situation.

The Step by Step blog article will be added soon.

You can Download the Exercise File and follow along by clicking on the link here below:

A picture containing drawing Description automatically generated

You can watch the Video tutorial by clicking here below

 

Share This Post
Have your say!
2 0

Leave a Reply

Your email address will not be published. Required fields are marked *

You may use these HTML tags and attributes: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <s> <strike> <strong>

SUBSCRIBE TO OUR EMAILING LIST AND RECEIVE FREE BOOK

Receive my Amazing Textbook “Pivot Tables From Zero To Hero” Totally FREE when you subscribe below to our emailing list.
SUBSCRIBE NOW
close-link