Dependent drop down

[Jayfaku]

I have a dependent drop down set and it is working fine in the first cell of worksheet 2. Now I want it to work for the other cells down the column. I am using the following:


=INDIRECT($E$2)

Cell E2 is a drop down list from sheet 1


I want the dependent drop down for the entire column (F) based on the drop down in column E


Thank you

 

[Gregm66]

Hi JayFaku

Try This Link it will help you.
https://www.youtube.com/watch?v=5nb84p2wX-c