Forum Discussion
Dependent Drop Downs across multiple rows in a spreadsheet
Hello. I've been trying to create a spreadsheet that has a dependent dropdown column. However, all the guides and advice I've seen so far have been functional only when you only need a single cell or...
Use =INDIRECT(B2) as the data validation 'rule' in C2 and copy it down. That should work just fine. See attached.
When you say "copy it down" what do you mean sorry? Is there way to automate the datavalidation? I thought it was applied on a cell-by-cell basis?
Selecting C2:C4 and creating data validation with source =INDIRECT(B2) works fine for me:
- Strange. I can only think that it must be something that makes Office 365 different to normal Excel then, because that exact text just refuses to work. I have to add the dollar signs to get it to do even let me accept it.
I don't have Excel proper, so I'll just have to try a different method I guess. Thank you anyway.
