Starting Dependent Drop Down List with Blank

**marcelkahn5** · 08-02-2015, 12:37 AM

Hi Everyone,

I have two dependent drop down lists and would like to have the second drop down list appear as a blank every time a selection is made from the first drop down list.

I am trying to achieve this with the same format from the attached sheet, and no macros please.

So from the attached sheet, I would like users to have a blank option for the Location Drop down list, and once a location is selected, a blank option will first appear on the Resin drop down.

Also, another thing I am trying to achieve is that no N/A appears in the Cost Cell every time a new location is chosen.

I appreciate you guys taking the time! Have fun!!!

**FDibbins** · 08-02-2015, 01:14 AM

I have two dependent drop down lists and would like to have the second drop down list appear as a blank every time a selection is made from the first drop down list.

Not possible with regular formulas or drop-down, it would need VBA

Also, another thing I am trying to achieve is that no N/A appears in the Cost Cell every time a new location is chosen.

Change the last "N/A" to just ""

**AmirSoft** · 08-02-2015, 01:41 AM

It is possible in VBA.
Ford is guiding you in better way.

**newdoverman** · 08-02-2015, 01:39 PM

This will prevent a new entry being made in B4 unless the entry in C11 is deleted.

In the data validation for B4 enter this formula:

Formula:

Please Login or Register  to view this content.

Upon entry of the formula you will get an error unless C11 is blank. If you get the error, continue.

This will not clear the entery in C11 but no entry in B4 is possible until C11 is deleted.

Starting Dependent Drop Down List with Blank

LinkBack

Thread Tools

Rate This Thread

Display

Starting Dependent Drop Down List with Blank

Re: Starting Dependent Drop Down List with Blank

Re: Starting Dependent Drop Down List with Blank

Re: Starting Dependent Drop Down List with Blank

Thread Information

Users Browsing this Thread

Similar Threads

Dependent Drop Down list to autofill next drop down with selective choices

Make a drop down dependent on an adjacent value being blank or not

[SOLVED] Dependent Drop down list with DEPENDENT DEFAULT VALUE

[SOLVED] Suppress drop-down list dependent on value chosen in another drop-down list

[SOLVED] Removing blank cells from a dependent drop list in a single column

[SOLVED] Column B drop down list with 2 options, columns C & E with dependent drop down lists

[SOLVED] Dependent Drop down list with DEPENDENT DEFAULT VALUE (e.g. Blank)

Bookmarks

Bookmarks

Posting Permissions