Super User is a question and answer site for computer enthusiasts and power users. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

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.

share|improve this question

Apply the validation rule =INDIRECT($A1) to column B down to B1000. Removing the fixed row reference will resolve the problem.

share|improve this answer

You must log in to answer this question.

Not the answer you're looking for? Browse other questions tagged .