How do I copy Subtotal groups?

K

Kris

Anyone know a way in which I can copy the subtotaled rows
of a worksheet to a new worksheet without copying all
the "in between" data???
 
J

Jean

Select the data to copy
Go to the Edit menu and Select "Go to"
Click the "Special" button
Check "Visible Cells Only"
Click OK
Choose Copy
Go to the new sheet and click Paste
 

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

Combine Sumifs with Subtotal 0
need help on either doing a loop and counting specific values orusing subtotal function 2
Additonal info into newly created Subtotal row 1
Getting Text data using the Data - Subtotal feature 1
SubTotal 1
Embed the same Excel multiple times 0
Problem with subtotal function 0
Can I use the subtotal function while a worksheet is protected? 0

Top