Home |
Search |
Today's Posts |
|
#1
|
|||
|
|||
separate worksheet into multiple worksheets by grouping
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. |
#2
|
|||
|
|||
separate worksheet into multiple worksheets by grouping
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 he http://www.rondebruin.nl/copy5.htm BPM001 wrote: 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 Excel FAQ, Tips & Book List http://www.contextures.com/tiptech.html |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Search multiple values & return single value - seperate worksheets | Excel Worksheet Functions | |||
Search in Multiple Worksheets | Excel Discussion (Misc queries) | |||
using multiple worksheets to do calculations | Excel Discussion (Misc queries) | |||
Transferring date from multiple worksheets to a "totals" worksheet. | Excel Discussion (Misc queries) | |||
Multiple worksheet master | Excel Discussion (Misc queries) |