| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
manually entering data in a cell with formula w/o losing the formu
I have a cell with "DOC STATUS" with four available options using a dropdown
list in that cell, ie, "due", "late", "revisions due", "completed". The next cell is "Current Due Date". For two of the four "DOC STATUS" the date is a calculation, ie the date in cell A3+20. For the remaining two "DOC STATUS" the date could be any date I designate. So I would like to have a formula reside in the "CURRENT DUE DATE" cell with the option of still doing manual entry in that cell WITHOUT destroying or overwriting the formula-because the DOC may end up reverting to a status where the formula calculation is useful. This is something very easy to do in database programs but I am having a hard time figuring it out in excel. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Hide cell formula without losing formatting abilities | Excel Worksheet Functions | |||
| entering new data in a saved spreadsheet without losing formulas? | New Users to Excel | |||
| Paste losing data after editing a cell | Excel Discussion (Misc queries) | |||
| How do I set up a cumulative column, without entering it manually | Excel Discussion (Misc queries) | |||
| How do I copy a formula/paste w/o losing the cell content? | Excel Discussion (Misc queries) | |||
Threaded Mode
