Display dropdown list after previous selection

HI,

I would like to do the following but can't get it to work. I appreciate some help.

This is what I would like to do:

IF C4 = NORTH OR EAST IN CELL B5 WILL BE DISPLAYED ORDER STATUS AND IN CELL C5 WILL BE DISPLAYED A DROPDOWN LIST WITH THE OPTIONS OPEN, SHIPPED, BOTH

IF C4= SOUTH OR WEST CELL B4 WILL BE DISPLAYED DO NOT VALIDATE

Thanks

Hi- I was looking for some similar functionality and I was able to get your code working "sort of"
My situation is slightly different in that I have a table, there are multiple columns.
I have two columns [Column 1] & [Column 2], each of them has a drop down list.
The values displayed in the drop down for [Column 2] are dependent on what was chosen from the drop down in [Column 1].
I have used the INDIRECT function to properly display the right list of values.

I have a couple of values in [Column 1], "Unstained" & "HE_Stain" for which I do not want the drop down to appear in [Column 2], all other values should activate the drop down list in [Column 2] and invoke the INDIRECT function.
I was able to use you code to get things working beautifully in the first row of my table, does exactly what I want it to.
Can't figure out how to get it to work on the rest of the rows in the table (which can vary depending on if the user is adding or deleting rows.

Including your code as I have modified it to work. G16 is the location of first row [Column 1], H16 is the location of first row [Column 2]

Please Login or Register  to view this content.

any help you can provide is much appreciated!