Copying a formula result

**Dave_A** · 02-27-2007, 09:25 AM

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

**Carim** · 02-27-2007, 09:28 AM

Hi,

There are several possibilities depending on what suits you best ...
a simple event macro could handle it automatically for you ...
Do you mind uploading a zipped copy of your worksheet ...?

**Dave_A** · 02-27-2007, 09:45 AM

cell aj30 changes every day with an external update query, in sheet 2 i have the if function, however everytime AJ30 changes, i want the value which is there to stay there and not move to the false (or 0)

cheers

**Carim** · 02-27-2007, 10:39 AM

Hi,

See attached ...

**Dave_A** · 02-27-2007, 10:54 AM

would you be able to explain how you did that for me as i need to create that for some of the other numbers on that sheet as well

edit:
i just tried to test it out,and maybe i have to do something, but when i change the date manually in ak30 it does change the value on the sheet 2, however if i then change the date from (say 27th to 28th) the value for the 27th figure just goes back to false, am i doing something wrong??

im only using office xp if thats an issue??