hey guys this seems to be a great forum...

im looking for some help with copying a formula. Basically i want to paste special a formula result automatically.

I have a if function set up so when 2 days corespond then in the 3rd cell it records the value, however when ever the date changes the value disappears, i can keep the value u there by paste special but i would love to set this up as an automatic thing once a value is recorded it records the value and deletes the formula, or the value doesnt change when the date (thus the condition) changes...

if someone could give me some guidence on this i would be estatic, i have spend a few hours on it and its driving me up the wall

cheers