Want to keep 'historical' data using formulas

  • Thread starter Thread starter raisingcain
  • Start date Start date
R

raisingcain

I use Excel 2002. I have a workbook where I enter data throughout the year
in one of the worksheets. There are 52 other worksheets, representing each
week of the year (with a beginning date and end date for each week.) Based
on formulas back to the ‘entry’ worksheet, data in the ‘weekly worksheets
change. I want the data in the worksheets representing weeks that have
already passed to not change, becoming historical records for those past
weeks, even though subsequent changes will be made in the ‘entry’ worksheet
and thus change the results in ‘future’ weeks.

Any ideas
 
Change the formulas to values in the cells/worksheets where you don't want the
formulas to update.

Select the range to fix
Edit|copy
edit|paste special|values

Is one way of doing it.
 
To "flatten" a worksheet...removing all the formulas but keeping the data:

1) Select the sheet
2) Press CTRL-A to select ALL the data on the sheet. You might have to press
CTRL-A several time to get it all
3) Press CTRL-C to copy everything
4) Click on Edit > PasteSpecial > Values

Now the sheet is flattened, no formulas are left on the sheet.
 
Back
Top