I have a spreadsheet with 8,000 rows of data found in columns A - K. Column A contains 15 distinct categories for the data. I understand enough to use the advanced filter to filter by column A and paste the results on a new tab, but I only can do this for one category at a time.
Is there a way to filter by all 15 categories in column A and put the results on 15 different sheets all at one time?
jamm
Is there a way to filter by all 15 categories in column A and put the results on 15 different sheets all at one time?
jamm