Try the following on a copy of your worksheet --

In the column of data to be copied, leave blank cells where the
subtotals would appear.
Copy the cells
Select the starting cell where the data will be pasted
Choose EditPaste Special
Under Paste, select All, and check the box for Skip Blanks
Click OK

EllenSwarts wrote:
I have a range of cells where the data is pulled from another spreadsheet,
then subtotaled. Is there a way to "protect" the subtotal formulas so that I
can highlight the entire range, copy and paste values only but not overwrite
the subtotals?


--
Debra Dalgleish
Contextures
http://www.contextures.com/tiptech.html