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