Data Validation

Copper Contributor

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.

1 Reply


No; you might use a formula to combine the ranges into a single range, and use that single range as source.