subtotal question?

W

wonderdogs828

I did a subtotal function. I was in trouble of extracting just thos
cells containing subtotals without copying those detailed cells.

How can I have a pure "subtotal" only worksheet?

Thank you
 
G

Govind

Hi,

Whats the formula you used. For picking up only subtotals, use

=SUBTOTAL(9,RANGE)

Regards

Govind.
 
Top