| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Copying formulas into protected cells.
I am creating a log sheet with a formula in Col A to number the row if there
is data input in Col B of that row. There are different sections of the log (i.e. Section 1 is from row 17 to row 37, section 2 from row 40 to 60, etc). Col A is protected. If they need to add rows, to enter more data into a section, how do I copy the formula to continue the numbering sequence? Thanks for your help. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Excel keeps copying formulas into other cells!! | Excel Discussion (Misc queries) | |||
| copying excel cells with formulas | Excel Discussion (Misc queries) | |||
| keeping cells locked and protected when copying and pasting | Excel Discussion (Misc queries) | |||
| Copying visible cells only on a protected worksheet | Excel Discussion (Misc queries) | |||
| Copying Formulas In Cells That Are Not Nested | Excel Discussion (Misc queries) | |||
![Stuart Mantel[_2_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Linear Mode
