separate worksheet into multiple worksheets by grouping

[Guest]

Looking for a method to separate a worksheet into multiple worksheets by
grouping, subtotals, etc. I have seen other programs that do it but haven't
found a way for Excel to do it. Example - multiple accounts listed by
region. Run a program or function to create a new tab by region that lists
all accounts for that region within it - but still maintain the master
worksheet.

 

[Debra Dalgleish]

I have sample worksheets that filter data to separate sheets:

http://www.contextures.com/excelfiles.html#Filter

Under Filters, look for 'Update Sheets from Master'

And Ron de Bruin has some samples here:

http://www.rondebruin.nl/copy5.htm