SubTotal feature needing to copy

  • Thread starter Thread starter Carla B
  • Start date Start date
C

Carla B

I have a client using Excel 2002. He is using subtotal to
view only those rows with subtotals. It will show him
rows that aren't in order like rows 14, 58, 266 etc... He
wants to be able to view the subtotal rows and copy and
paste them into another sheet. When he tries that, it
copies those hidden rows also. Any way around this?

Thanks,
Carla
 
Carla

Apply the subtotal to the level he needs and then do Edit>Go
To...>Special>Visible cells only and paste to the new sheet

--
HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England
(e-mail address removed)
 
Back
Top