I have a data table with groups as column headers and names and emails as rows. I want to export data to another spreadsheet in the same document, which would only display members who belong to a certain group, which would be displayed in separate spreadsheets.
I did dynamically linked them using Importrange, filtered data out and hid irrelevant groups.
The problem is if the master data table has any changes (say, one person was added to group 1), I want them to appear in filtered results for each group without having to refresh the filtering. Is this possible?
I tried to search everywhere, but nothing was quite what I needed.
Best Answer
Instead of using the Google Sheets UI filters, use a formula to filter the results.
To do this you could use functions like FILTER and QUERY