software

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

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 Editgt;Paste Special
Under Paste, select All, and check the box for Skip Blanks
Click OK

EllenSwarts wrote:
gt; I have a range of cells where the data is pulled from another spreadsheet,
gt; then subtotaled. Is there a way to quot;protectquot; the subtotal formulas so that I
gt; can highlight the entire range, copy and paste values only but not overwrite
gt; the subtotals?--
Debra Dalgleish
Contextures
www.contextures.com/tiptech.htmlI'm not sure how that helps me. Must I then enter each subtotal formula?
That's what I'm trying to avoid. What I'd like to do is copy the entire
column as values EXCEPT where there's a subtotal formula -- then I want the
subtotal formula to stay.
quot;Debra Dalgleishquot; wrote:

gt; Try the following on a copy of your worksheet --
gt;
gt; In the column of data to be copied, leave blank cells where the
gt; subtotals would appear.
gt; Copy the cells
gt; Select the starting cell where the data will be pasted
gt; Choose Editgt;Paste Special
gt; Under Paste, select All, and check the box for Skip Blanks
gt; Click OK
gt;
gt; EllenSwarts wrote:
gt; gt; I have a range of cells where the data is pulled from another spreadsheet,
gt; gt; then subtotaled. Is there a way to quot;protectquot; the subtotal formulas so that I
gt; gt; can highlight the entire range, copy and paste values only but not overwrite
gt; gt; the subtotals?
gt;
gt;
gt; --
gt; Debra Dalgleish
gt; Contextures
gt; www.contextures.com/tiptech.html
gt;
gt;