I have a query that contains over 400 rows.
One column contains an identifier that I'd like to be able to automatically filter onto separate sheets based on the data in that column. There are possibly 200 unique values in that column, so it would mean creating nearly 200 sheets.
I know that you can use pivot table options to do this based on a filter.
I also know how to do this very simply in google sheets with the formulas of query and filter.
I'd really like to have the ability to create these sheets en masse rather than individually. And I really need them to remain 'live' and update upon refresh from the original query.
***Edited to include attachment...Thanks, Ali!!!
Thanks,
Rachel
Bookmarks