Using Data Validation based on input in another cell

Question

Using Data Validation based on input in another cell

Anonymous

I would like to use a data validation sequence to set a maximum input amount for my cells B9-15. Simple enough normally. However, I want the max to pull from a list on another chart (J3-11) based on my input in a specific cell (B6).

Any Thoughts?

Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

1 answer

Answer 1

HansV 462.4K MVP Volunteer Moderator

See Create Dependent Drop-Down Lists

Share via

Using Data Validation based on input in another cell

1 answer