Locking a Cell after It's Value is Calculated.

[picktr]

I have One Cell whose value is constantly changing once a week.
The results of that cell, I would like to have placed in
differents cells, once a week.
EX:
In worksheet1
Input in cell WK3, resulting calculation ends in cell M3, then
cell M3 is copied to worksheet2, A1 (=worksheet1M3) I got this!

Input in cell WL3, resulting calculation ends in cell M3, then
M3 is copied to worksheet2, A2:
The problem is that cell A1 changes to the new number
HELP!

Can I lock cell A1 after the value is copied to it?
Can I set conditions (time / date) on the cell after the value i
copied to it so it won't change?

I use the results of worksheet2, A1, A2, etc. for seperat
calculations.

If more clarification is needed I can email
a copy of the sheet.

Tom (e-mail address removed)

 

[Stefan Hägglund [MSFT]]

Hi Tom!

I would suggest that you paste the copied cell to Worksheet2 as value (Edit,
Paste Special, check "Values" and click OK).
Now you only get the value, not the formula that show the value in Sheet1!M3

Best regards

Stefan Hägglund
Microsoft

 

[picktr]

Thank You!

 

[Otto Moehrbach]

Tom
I take it that you want these things to occur automatically. What
Stefan gave you is a manual copy/paste - values procedure. If that is what
you want, then you already have it.
But if you want to automate this transfer of data you need an event
macro to do it for you and the result won't be volatile (it will not change
later when the source is changed). Such a macro would be triggered to copy
the data when a change is made to the contents of WK3.
If this is what you want, post back or contact me direct at
(e-mail address removed)
Remove "cobia97" from my email address. HTH Otto