Is it possible to limit a data validation list to only cells that are only visible in any given range?
This picture shows what I want to do, (Thanks)
limit_validation.jpg