How do I copy sub total data only onto a new worksheet?

K

khuff

When subtotaling a large amount of data I would like to be able to copy and
paste just the subtotal-ed information. When I try to do this I cant figure
out how to eliminate the underlying data from copying too.
 
S

Shane Devenshire

Hi,

Select your data and press F5, Special, Visible cells only, OK. Then copy.

If this helps, please click the yes button

Cheers,
Shane Devenshire
 
K

khuff

Thanks Shane,

That F5 key seems to be helpful to know. Is there another way to get to that
tool other than using the F5 key?
 

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

Need Help with a VBA subroutine 0
Getting Text data using the Data - Subtotal feature 1
How do I remove the top half of a block interval? 1
Pasting a cell into bookmarked table from excel vba 1
Formula's won't read copy / pasted data ? 2
VBA Copy values only onto new workbook 1
How do I summarize spending for charting?? 1
How do I Copy and Paste onto Same Rows after filtering out rows. 2

Top