Want to keep 'historical' data using formulas
 

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

--
raisingcain

Want to keep 'historical' data using formulas
 

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.

raisingcain wrote:

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

--
raisingcain

--

Dave Peterson

Want to keep 'historical' data using formulas
 

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.

--
"Actually, I *am* a rocket scientist." -- JB
(www.MadRocketScientist.com)

Your feedback is appreciated, click YES if this post helped you.


"raisingcain" wrote:

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

--
raisingcain