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