Problem

P

picktr

I have One Cell whose value is constantly changing once a week.

Input in WK3, resulting calculation ends in cell M3
M3 is copied to worksheet2, A1 (=worksheet1M3) I got this!

Input in WL3, resulting calculation ends in cell M3 (again)
M3 is copied to worksheet2, A2 (cell A1 changes to the new number)
HELP!

Can I lock a cell 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?

Any help is always appreciated.

Tom (e-mail address removed)
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Locking a Cell after It's Value is Calculated. 3
Automatically copy input from one cell to another 2
Case format for getting cell value from a worksheet. 3
Case Statement Format for getting cell value from a worksheet 1
Running Total in a cell. 1
Copy Array to Array, how to and should I? 13
Formula Help 2
Conditional Format with Name Range? 1

Top