I have created a spreadsheet with a dependent data validation drop down list, is there a way that I can copy the validation drop down as I want to use this for each row. If I select Airframe in the 1st row, the dependent drop down will show Fin, Tail, Elevators etc. I might have the row below with Prop which would have a dependent data validation drop down of Blades, Spinner.
I want to carry out this task for multiple rows therefore currently I'd use this formula in cell E1 =INDIRECT($B$1) to get the value Airframe from the 1st drop down which will display Fin, Tail, Elevators.
For the next row down, I'd need to use =INDIRECT($B$2) and so on for the next row. Is there a way to copy this subtle difference down the rows as it is in the data validation cell?
Solved by X. E. in 26 mins