Hi,

Select the column, and press Alt+; (short cut key for selecting visible
cells), copy the visible cells and then paste in the desired range

--
Regards,

Ashish Mathur
Microsoft Excel MVP
www.ashishmathur.com

"Klutz" wrote in message
...
I have an Excel spreadsheet which consists of data with sub-totals. How do
I
copy and paste only the sub-total values to another spreadsheet?