subtotals selection problem

[stuart.munn@angus-it.com]

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 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

[Dave Hawley]

Hi Stuart

Not too sure I follow but when the data is showing only the data you want, select an sing cell within it, Push F5, click Special-Visible cells, Ok. Now copy and paste special-Values only.

[stuart.munn@angus-it.com]

Dave

Thanks it was just what I wanted... a big time saver!

Cheers

Stuart