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.