| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Is there a way to subtotal to seperate sheets in excel?
I need to find a way to place subtotals on seperate pages. Copy and paste
1000 times over takes hours too long. Any help would be greatly appreciated! Thanks! |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Is there a way to subtotal to seperate sheets in excel?
What do you mean, placing subtotals on separate pages?
Have you used Excel's subtotal command to create the subtotals? Collapse the view down to just the subtotal rows. Now select those rows and press the F5 key & click on the Special button. Choose 'Visible cells only' & click on OK Now copy the selection, move to the other sheet, and paste "Eric Pulliam" wrote: I need to find a way to place subtotals on seperate pages. Copy and paste 1000 times over takes hours too long. Any help would be greatly appreciated! Thanks! |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Excel Subtotal problem | Excel Worksheet Functions | |||
| excel newb needs some help making multiple sheets communicate for ecommerce project! | Excel Discussion (Misc queries) | |||
| Vlook up for matching data in two seperate sheets | Excel Discussion (Misc queries) | |||
| Excel should open workbooks in seperate windows like Word does | Excel Discussion (Misc queries) | |||
| How to make one CSV file from two Excel sheets? | Excel Discussion (Misc queries) | |||
Linear Mode
