Having Trouble Applying Forumla to whole column

[Kirstyamanda]

Hi there, me again, back with my 3 dependent drop downs!

Good news, I've got them all sorted! However, it seems that I have to go through each of the last 2 columns, and apply the formula so it is dependent on the choice from the first drop down menu in its corresponding cell..example, E8 choice is dependent on D8 choice which is dependent on C8 choice...surely there is a way to have that formula applied down the whole columns so I don't have to go down each cell in both columns?!

Or am I talking nonsense..

Any help is extremely appreciated!

[FDibbins]

Not really sure I understand, but if you copy the DD cells down, they should adjust as needed?

[ChemistB]

You say they are 3 dependent dropdowns? so that would mean no formulas. You can copy the data validation down all columns. An uploaded file might help explain a lot if we're on the wrong track (Go Advanced>Manage Attachments)

[Kirstyamanda]

I am using the INDIRECT formula for the last 2 drop downs, the first one being =INDIRECT($C$5) C5 being the first cell in the second drop down column, then INDIRECT($D$5) for the last drop down. I need that formula copied down each column, corresponding with the row numbers, but I don't know how to do it.

[FDibbins]

Remove the $'s, then just copy the DD down

[Kirstyamanda]

Fantastic, thanks very much!

[FDibbins]

Happy to help, thanks for the feedback