| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
Copy Subtotals to another worksheet
When using excel sub total function. How do I copy the sub total to another
worksheet? |
|
#2
|
|||
|
|||
|
Hi
Reduce the grouping to show just the information you want. Hit F5 and select Visible Cells. Ctrl+C to copy. Move to where you want the totals and click Edit / Paste Special / Values. -- Andy. "Webs" wrote in message ... When using excel sub total function. How do I copy the sub total to another worksheet? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Copy from worksheet to another x times | Excel Discussion (Misc queries) | |||
| copy link from next worksheet | Excel Worksheet Functions | |||
| Copy answer to another worksheet | Excel Discussion (Misc queries) | |||
| how do I make a copy of a worksheet and retain formulas but not data | Setting up and Configuration of Excel | |||
| Copy worksheet with Pivot Table and break link to original workshe | Excel Worksheet Functions | |||
Linear Mode
