How do i get a drop down within a drop down to continue down a column?

[Shellyisme]

I have a drop down working awesome and even a drop down within the drop down. How do I get the formatting right so that the second drop down will work correctly for all 150 rows and not just the top row?

I am using =INDIRECT($a$4)
Please help!

Shelly

 

[Shellyisme]

I figured it out! It was a duh moment when I did too! Anyways: =INDIRECT(A4). Then Shift Control and down arrow to highlight the rows. Then Control D to copy Data Validation down the rows.