I have a database which i have used subtotals on. Can I copy just the subtotals to another sheet without selecting the individual cells ie close the subtotal view to only show the subtotal values , highlight them all then copy and paste ?
-
If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.
Copy visible cells
- Thread starter Peter100
- Start date
Peter_SSs
MrExcel MVP, Moderator
- Joined
- May 28, 2005
- Messages
- 65,372
- Office Version
- 365
- Platform
- Windows
Welcome to the MrExcel board!
The steps are:
1. Select the (collapsed) Subtotals range.
2. Alt+; (or Blacky's method) to select the visible cells only.
3. Copy
4. Move to where you want and Paste.
Upvote
0
Note: This only works if you paste into a worksheet that was opened in the SAME INSTANCE of Excel. If you try to paste into a worksheet in a new instance of Excel it will paste all the cells, not only the visible ones (for Excel 2007).
Upvote
0
Peter_SSs
MrExcel MVP, Moderator
- Joined
- May 28, 2005
- Messages
- 65,372
- Office Version
- 365
- Platform
- Windows
Sure, but I guess that wouldn't be such a common occurrance.
In any case a few extra steps should achieve the same result.
After copying to the second instance of Excel ..
1. Apply AutoFilter
2. (Custom) Filter the relevant column for 'does not end with' ' Total' (or ' Count', ' Average' etc - depending on your type of SubTotal)
3. Select & delete all the rows below the heading row
4. Remove the AutoFilter
Upvote
0
Similar threads
- Solved
