I want to feed a sheet automatically as we could do on Google sheet with the Query function. Is this possible with formulas?
for example I want to highlight a whole column from sheet 1 in a new sheet 2 based on a criteria from sheet 1
Help Article Resources
Check out the Formula Handbook template!