Subtotal and Auto Filter

[Paolo]

I have a worksheet that lists total sales for the month for 8 locations.
I have subtotaled the sheet so I can autofilter by location, vendor, class of product, sales rep, etc.

I send each location only their section monthly, they can filter by any column except of course location.
I haven't been able to figure out how to separate out each location into a separate file, maintaining all the other filters.

Time runs short, so I end of saving the file 8 times, then delete the rows that don't belong to that location.
It's cumbersome, and I know it's not the best way.
What should I be doing instead?

 

[Debra Dalgleish]

There's a sample workbook on my web site, that sends data to individual
sheets from a table on the master sheet

http://www.contextures.com/excelfiles.html#Filter
under the heading 'Update Sheets from Master'

And if you need to keep formulas intact:

http://www.contextures.com/excelfiles.html#Function
under the heading 'Extract Items with Formulas'

You could adapt these to send the data to a new workbook.