stuart.munn@angus-it.com
New Member
- Joined
- Mar 24, 2002
- Messages
- 4
Hopefully someone has a solution that wil ave me a bit of time.
I have a long list of items and values, that I am using the subtotal tool on. My problem is when I collapse the list to show just the subtotal values, I want to copy only the subtotals and work on them. I am doing this by selecting them using the <Ctrl> <mouseclick> method and then copy and pasting them onto another sheet. This is a bit clumsy and takes ages to do.
Is there an easier method of copying just the subtotals values so I can work on them?
Thanks..
Stuart
I have a long list of items and values, that I am using the subtotal tool on. My problem is when I collapse the list to show just the subtotal values, I want to copy only the subtotals and work on them. I am doing this by selecting them using the <Ctrl> <mouseclick> method and then copy and pasting them onto another sheet. This is a bit clumsy and takes ages to do.
Is there an easier method of copying just the subtotals values so I can work on them?
Thanks..
Stuart