I have a worksheet (A) which gets updated by cell values in another worksheet
(B). Worksheet A is only valid up to a particular date. After that date, I
want to be able to lock every value in the worksheet A so that I can still
update worksheet B (manually) and NOT have worksheet a updated. Is there a
way to do this or do I need to go to a VBA solution?

thanks

Copy|paste special|values

When you want.

AndrewOZ wrote:

I have a worksheet (A) which gets updated by cell values in another worksheet
(B). Worksheet A is only valid up to a particular date. After that date, I
want to be able to lock every value in the worksheet A so that I can still
update worksheet B (manually) and NOT have worksheet a updated. Is there a
way to do this or do I need to go to a VBA solution?

thanks

--

Dave Peterson

Thanks Dave - works a treat!


"Dave Peterson" wrote in message
...
Copy|paste special|values

When you want.

AndrewOZ wrote:

I have a worksheet (A) which gets updated by cell values in another
worksheet
(B). Worksheet A is only valid up to a particular date. After that date,
I
want to be able to lock every value in the worksheet A so that I can
still
update worksheet B (manually) and NOT have worksheet a updated. Is there
a
way to do this or do I need to go to a VBA solution?

thanks

--

Dave Peterson