Excel 2003 Subtotal question

[jared511]

Hello...

I have some data subtotaled, and when I try to copy and paste the data it includes all the rows in between the new "subtotaled" rows. I know sometimes it shows dotted lines inbetween and allows me to copy just the data that is in view, but lately it does not work. Any ideas?


Thanks,
Jared

 

[Latchmaker]

Select the data you want to copy then select Edit ...GOTO....SPECIAL....Visible Cells Only then right click copy.

 

[jared511]

you are my hero. Thanks so much