| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
how to overwrite a value without loosing the formula?
A weekly workbook has 7 sheets, one for each day.
My function say in cell a2 (=prevDay(a1)) puts the value from cell a1 of the previous day into cell a2. Sometimes I need to overwrite this value manually. Is there a way of doing this without loosing the formula in a2? thanks in advance, /mark |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| I'm loosing colour when copying charts from excel to word. | Charts and Charting in Excel | |||
| Excel prompts me to save a copy or overwrite file. | Excel Worksheet Functions | |||
| Help - Loosing my settings and my mind. | Excel Discussion (Misc queries) | |||
| Add data to cell w/o loosing initial data | Excel Discussion (Misc queries) | |||
| Overwrite changes dialogue box | Excel Discussion (Misc queries) | |||
Threaded Mode
