Here is my delimma. I have a workbook with two worksheets, one being
the source data, and the other being the weely data. The source data
sheet is updated weekly with updated data. The weekly data worksheet
is updated weekly by this source data. However in the weekly data
worksheet, each week is represented by a column. All of the cells look
to the source data worksheet for its calculations. Is there a way to
lock in the value calculated by the formula in the cells to preserve
the current weeks data when next weeks data is entered? This is giving
me a major headache, as I can't figure out how to "lock" the values in
the cells.

Thanks in advance.