Is it possible to reference filtered data from one sheet to another in Google Sheets?
I use the filter button to sort in a master sheet. I then use this formula in a new sheet:
That formula is referencing and showing everything from column A in the master sheet in the new sheet. After I filter the data in the master sheet, the new sheet still shows all of column A.
How do I get the new sheet to only show what is filtered within the master sheet?
The point of the new sheet is to have our logo, contact info, and rows highlighted on it so if we need to share with clients it looks more professional.