Forum Discussion
Data Validation
Hi there,
Is it possible to create a data validation with a drop down from a range but using ranges from multiple tabs? So it would be the same cells of different tabs. e.g M17:M70 but with 3 different tabs.
No; you might use a formula to combine the ranges into a single range, and use that single range as source.
