| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Moving data makes unwanted change to formula
I have a spreadsheet for recording room usage. Column A has StartTime,
Column B has EndTime and Column C has formula EndTime - Startime. Each day is split into 6 periods. If I move (cut & paste) a booking from row 2 to row 4, the formula in C2 adjusts to the new location of the data (even when absolute reference is used) and the forumula in C4 becomes =#REF-#REF. I can't cut & paste the whole line of data as Column C is protected and I'd be unable to re-insert the formula. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| One change makes many changes | Excel Worksheet Functions | |||
| How to change a MATCH formula when moving it to a different sheet | Excel Discussion (Misc queries) | |||
| Unwanted change in width of columns when showing formula. | New Users to Excel | |||
| Updating data makes formula wrong | Excel Discussion (Misc queries) | |||
| If someone makes a change does this automatically refresh? | Excel Discussion (Misc queries) | |||
Threaded Mode
