Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
splitting a worksheet into multiple worksheets
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. -- JLevine |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
splitting a worksheet into multiple worksheets
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 levine52 wrote: 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. -- JLevine -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Splitting a Worksheet into Multiple Sheets | Excel Worksheet Functions | |||
How do I combine multiple worksheets into one worksheet? | Excel Worksheet Functions | |||
HOW DO i COLLATE MULTIPLE WORKSHEETS INTO ONE WORKSHEET | Excel Discussion (Misc queries) | |||
can I put a multiple worksheets within a worksheet(s) in a spreads | Excel Discussion (Misc queries) | |||
Need to have multiple worksheets use a single worksheet | Excel Worksheet Functions |