Excel Data Validation

Copper Contributor

How do I make a data validation list change based on what i select from a different data validation?

1 Reply

@PatrickHansen 

 

How do I make a data validation list change based on what i select from a different data validation?

 

I'm attaching an example of how to do that. This does require current versions of Excel, as it makes use of some dynamic array functions. If you need more help, please come back with a more complete description of what you're trying to do.