| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
freeze values in a cell derived from another sheet in a workbook
In Excel 2003
Values in Column "B" in sheet 1 (total of yearly expense for 2006 in various categories) derive their values from cells in sheet 2 (the sum of monthly expenses in a category for the year). Once all values for 2006 have been entered in Sheet 2, how do I freeze the values in Sheet 1, column "B" so that they don't change as I update the expense data on Sheet 2 for 2007 (now to be read by column C on Sheet 1)? Thank you. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Sumproduct issues | Excel Worksheet Functions | |||
| Cell References | Excel Discussion (Misc queries) | |||
| Using an offset formula for the reference in a relative reference | Excel Worksheet Functions | |||
| LINKEDRANGE function - a complement to the PULL function (for getting values from a closed workbook) | Excel Worksheet Functions | |||
| Possible Lookup Table | Excel Worksheet Functions | |||
Threaded Mode
