Hi Bryan,
no need to send the file just tell me what do you have in your spreadsheet
in the different worksheets like
Sheet1 column a
Row1 100
Row2 200

Sheet2 Column a
week1 weed2
1 2


"Bryan De-Lara" wrote:

Eduardo, I couldn't send the file. Do I need your e-mail address?
Bryan.

wrote in message
...
On 3 Dec, 19:18, Eduardo wrote:
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- Hide quoted text -

- Show quoted text -

Thanks again Eduardo, I don't have the facility here at work to attach
any files so will do it from home.