| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| skip every other row when copying formula | Excel Discussion (Misc queries) | |||
| Copying from Subtotal Data | Excel Discussion (Misc queries) | |||
| Can you paste to protected spreadsheet and skip over locked cells? | Excel Discussion (Misc queries) | |||
| Skip hidden rows while copying down in excel? | Excel Discussion (Misc queries) | |||
| How do I skip blank cells when copying over a range of cells? | Excel Discussion (Misc queries) | |||
Linear Mode
