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