Dependent Data Validation Drop Down List for multiple rows?

Hello,

I have created a spreadsheet with a dependent data validation drop down list, is there a way that I can copy the dependent validation drop down as I want to use this for a number of separate rows within the spreadsheet. Each row will represent an aircraft system failure. 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 Propeller problem 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 the Data Validation formula in cell E1 =INDIRECT($B$1) to get the value Airframe from the 1st drop down which will then allow me to select either Fin, Tail, Elevators from the dropdown.
For the next row down, I'd need to use =INDIRECT($B$2) and so on all the way down the rows. Is there a way to copy this subtle difference down the rows as it is in the data validation cell?

Thank you,

Hello Marvin,

Thanks for the quick reply. I'll be using AutoFilter to sort data once I've entered it however I need to find a way to limit what can be selected based on System. There will be 16 systems total and with an average of 10 sub systems (dependent data validation drop down choices). Each day data is manually added as problems arise and then this data will be sorted using pivot tables.
Does this make sense?

Regards,

Marvin

Copy that, I'll give that a go...

Hello Marvin,

Here is the file with added comments. In the Final look required columns G and H are where I'd be using the particular drop downs.
In Cell C7 on the Issue Sheet I've included comments.

Regards,

Hi Marvin,
I'll read up on that today.

Thanks.

Hi Marvin/All

I'm struggling with this one.
Do you have an example of something that might be what I'm after that I could play with?
I want to use drop downs whilst entering data onto new rows.

Many thanks..

Hello,

Quick update, I've managed to fix the problem I had and it was simple!

I was trying to use E1 =INDIRECT($B$1) however I couldn't get it to work when I dragged the formula down to multiple rows.
What I needed to do was remove the $ after the B, to give E1 =INDIRECT($B1)

Regards,