Hi Bryan,
Make a macro so after the number is actualize make a copy paste values so
that number will remain the same

" wrote:

How can I lock a cell after data has been entered. What I have is a
sheet that takes data from another sheet i.e. I have counta to count
names. That is on sheet 1. The count remains on sheet 1 and is used on
another calculation, but it's also used on sheet 4. There it's used on
a different calculation by week number. The problem I have is say on
week 1 it's 79, it does it's calculation which should remain the same.
But on week 2 if another name is added then it updates week 1 as well
which is incorrect. Is there any way that week 1 cell once past that
date can be locked automatically so that it doesn't change. Any help
would be appreciated.