You can copy and paste the data to separate sheets, manually or
programmatically.

Or, you could create a pivot table from the data, and use page fields to
filter it, so it shows only the data you're interested in. From a pivot
table, you can use a Show Pages command, to create a new sheet for each
item in a page field.

Scott wrote:
How do you get subtotaled data on individual tabs based on the subtotal
criteria?


--
Debra Dalgleish
Contextures
http://www.contextures.com/tiptech.html