Need Help in copying source formula from dropdown validation and pasting it in other rows.

[gaurav4698]

I want to replicate formula in D12 ,D13 dropdown validation into below cells,
EG. in D11 dropdown validation i have formula as =INDIRECT($C$12) and i want =INDIRECT($C$12) formula in D12 and so on ,How can it be done ?

 

[gaurav4698]

Got the solution ,
Just instead of $C$12 i changed it to C12