I have managed to do a conditional drop down list from another list – however I now can't seem to copy it down the 1000 rows I need it to work on.
For example, in column A the user would select either:
Fruits
Veggies
Other
Then in column B, the drop down list would be conditional upon what was selected in A. So if the user selected Fruits
, the drop down list in B would be: Apples, Peaches
etc. Or if the user selected Veggies
in column A's list, the list in column B would be: Corn, Beans
etc.
I did the formula and I have:
=INDIRECT($A$1)
in the Validation tab etc.
The issue is: I have 1000 rows going down, and I don't know how to copy it all the way down, as when I do it shows the same options.