Oct 19 2023 07:41 AM
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.
Oct 19 2023 07:50 AM
No; you might use a formula to combine the ranges into a single range, and use that single range as source.