There is a way to do a data validation between 2 different Google Sheet?
I mean, I have 2 different types of Sheets: 1 - Master with all the information 2 - Various Sheets where i import some data from the Master
Now, i use the IMPORTRANGE function where i link to these second types of sheets each time I must do the data validation, but it is very long to do every time. There is a way to link directly to the unique Master Sheets (like a Database central)?
data validation and conditional formatting across 2 different spreadsheets or sheets is possible if you wrap your reference/range into INDIRECT
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With