SubTotal feature needing to copy

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
 
N

Nick Hodge

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)
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Getting Text data using the Data - Subtotal feature 1
hidden rows, column copy-paste 0
can i automatically copy subtotals in excel to another s/sheet? 1
Copying only subtotals 1
subtotal titles 1
subtotal copy and paste 3
Using copy/paste after subtotalling 3
Copying from Subtotal Data 2

Top