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.

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.

On 3 Dec, 17:21, Eduardo wrote:
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.- Hide quoted text -

- Show quoted text -

Thanks Eduardo, I thought that maybe the case, and it's caused me a
big shudder, macro's are not me.com, thanks for the reply.
Bryan.

Do you need help with the macro I can write one for you and you can have it
assigned to a bottom so you can run every time you want

" wrote:

On 3 Dec, 17:21, Eduardo wrote:
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.- Hide quoted text -

- Show quoted text -

Thanks Eduardo, I thought that maybe the case, and it's caused me a
big shudder, macro's are not me.com, thanks for the reply.
Bryan.

On 3 Dec, 18:35, Eduardo wrote:
Do you need help with the macro I can write one for you and you can have it
assigned to a bottom so you can run every time you want



" wrote:
On 3 Dec, 17:21, Eduardo wrote:
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.- Hide quoted text -

- Show quoted text -

Thanks Eduardo, I thought that maybe the case, and it's caused me a
big shudder, macro's are not me.com, thanks for the reply.
Bryan.- Hide quoted text -

- Show quoted text -

Eduardo, yes please that would be great if you could. I need to
operate on cells B8 to BA8 = 52 weeks.

Bryan

Hi Bryan,
Do me a favour, send me an example of the spreadsheet where you have the
information by week and the sheet where you take the information from. I
don't need the 52 weeks just 2 columns and I will populate to the others but
I need to see how you get the information so I can see the best way. Thank
you. I am leaving today but tomorrow morning I will send you the macro and
the instructions to run it

" wrote:

On 3 Dec, 18:35, Eduardo wrote:
Do you need help with the macro I can write one for you and you can have it
assigned to a bottom so you can run every time you want



" wrote:
On 3 Dec, 17:21, Eduardo wrote:
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.- Hide quoted text -

- Show quoted text -

Thanks Eduardo, I thought that maybe the case, and it's caused me a
big shudder, macro's are not me.com, thanks for the reply.
Bryan.- Hide quoted text -

- Show quoted text -

Eduardo, yes please that would be great if you could. I need to
operate on cells B8 to BA8 = 52 weeks.

Bryan