Advanced Filter

[Jamm_027]

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

 

[c_m_s_jr]

You could set up 15 different sheets and then once you update your data hit a button that would refresh all of the 15 sheets with the new data.

There is more elegant VBA that would just copy and paste, but I can help you with the VBA to do the 15 categories and then refresh on the button.

 

[haider378]

why your not using pivot table.