splitting a worksheet into multiple worksheets

[levine52]

I have a worksheet that contains many rows of information, sorted by manager
name. Is there a way to quickly split the worksheet into multiple worksheets
that only have the information for an individual manager? I think of this as
sort of subtotalling and then splitting.

 

[Dave Peterson]

I'd look at these techniques:

Ron de Bruin's EasyFilter addin:
http://www.rondebruin.nl/easyfilter.htm

Code from Debra Dalgleish's site:
http://www.contextures.com/excelfiles.html

Create New Sheets from Filtered List -- uses an Advanced Filter to create
separate sheet of orders for each sales rep visible in a filtered list; macro
automates the filter. AdvFilterRepFiltered.xls 35 kb

Update Sheets from Master -- uses an Advanced Filter to send data from
Master sheet to individual worksheets -- replaces old data with current.
AdvFilterCity.xls 55 kb