Skip Copying a protected cell with subtotal
 

Dear all,

I have a preset worksheet in which the total cell is protected. I need to
fill in the figures in this worksheet except for the total each month,
actually these figures are in an exact format of another workbook. But since
the subtotal cell is protected I cannot copy the whole range from the
source, instead I need to key in manually or copy part by part, is there any
function that can help me to skip the total. Pls see the sample below.

A B
Apple 10
Orange 20
Subtotal 30 (this cell is protected)
Banana 5
Pear 6
Subtotal 11(this cell is protected)
Total 41(this cell is protected)

How can I copy from Apple to Total rows and skip the protected cells.

Thanks for your help in advance
et

Skip Copying a protected cell with subtotal
 

=B2+b3=b5+b6
--
I think this would work if Apple is b2, and orange is b3 ect....

Ladyhawk

"et" wrote:

Dear all,

I have a preset worksheet in which the total cell is protected. I need to
fill in the figures in this worksheet except for the total each month,
actually these figures are in an exact format of another workbook. But since
the subtotal cell is protected I cannot copy the whole range from the
source, instead I need to key in manually or copy part by part, is there any
function that can help me to skip the total. Pls see the sample below.

A B
Apple 10
Orange 20
Subtotal 30 (this cell is protected)
Banana 5
Pear 6
Subtotal 11(this cell is protected)
Total 41(this cell is protected)

How can I copy from Apple to Total rows and skip the protected cells.

Thanks for your help in advance
et

Skip Copying a protected cell with subtotal
 

you can also do an = and then select the cells you want to total up
--
thank you, Lorie


"Lorie" wrote:

=B2+b3=b5+b6
--
I think this would work if Apple is b2, and orange is b3 ect....

Ladyhawk

"et" wrote:

Dear all,

I have a preset worksheet in which the total cell is protected. I need to
fill in the figures in this worksheet except for the total each month,
actually these figures are in an exact format of another workbook. But since
the subtotal cell is protected I cannot copy the whole range from the
source, instead I need to key in manually or copy part by part, is there any
function that can help me to skip the total. Pls see the sample below.

A B
Apple 10
Orange 20
Subtotal 30 (this cell is protected)
Banana 5
Pear 6
Subtotal 11(this cell is protected)
Total 41(this cell is protected)

How can I copy from Apple to Total rows and skip the protected cells.

Thanks for your help in advance
et