Saving A One Off IF Result

[Rebecca]

3 A B C D E
4 Date Number Result 1 Result 2 Date
5 15/02/2009 1345.5 15/02/2009
6 16/02/2009

Hi, Don't know if this makes any sense to anybody but I'll give it a try
anyway.
I can set up an IF formula in C5 to send
contents of B5 to C5 if the date in A5 matches the date in E5.
My
problem is:- How or what do I have to do to the formula to be able to "Save"
that result in C5 even when the contents of A5 & B5 change. Because then
there is another IF formula in D6 to send the new contents of B5 to D6 if the
new date in A5 matches the date in E6.
Any help in this matter is
appriciated.

 

[Simon Lloyd]

You would need VBA code to do that, would you be comfortable wit

3 A B C D
4 Date Number Result 1 Result 2 Dat
5 15/02/2009 1345.5 15/02/200
6 16/02/200

Hi, Don't know if this makes any sense to anybody but I'll give it
tr
anyway
I can set up an IF formula in C5 to sen
contents of B5 to C5 if the date in A5 matches the date in E5
M
problem is:- How or what do I have to do to the formula to be able t
"Save
that result in C5 even when the contents of A5 & B5 change. Becaus
the
there is another IF formula in D6 to send the new contents of B5 to D
if th
new date in A5 matches the date in E6
Any help in this matter i
appriciated












-
Thanks Beck

--
Simon Lloy

Regards,
Simon Lloyd
'The Code Cage' (http://www.thecodecage.com

 

[Rebecca]

--
Thanks Becky

You would need VBA code to do that, would you be comfortable with
that?##Rebecca;231282 Wrote:

Hi Simon,
Being new at excel, I have not ventured into VBA as of yet but I am always
willing to have a go.
If I give you the simple IF formula that I have entered in c5 being:-
=IF(a5=e5,b5) would you be willing to tell me what to do or is it to
complicated that really I should go and learn about VBA first.
Becky.

 

[Simon Lloyd]

Becky, if you want, join the forum below (it's free) where i can tak
you through a series of examples and workbooks so that you understan
what is happening, can follow it and then maybe adapt it for future use
if you are new to VBA you will need some guidance whether it be here o
anywhere else, all the folk that can do VBA are STILL learning! ;

-
Thanks Beck





Hi Simon
Being new at excel, I have not ventured into VBA as of yet but I a
alway
willing to have a go
If I give you the simple IF formula that I have entered in c5 being:
=IF(a5=e5,b5) would you be willing to tell me what to do or is it t
complicated that really I should go and learn about VBA first
Becky


Lloyd' (http://www.thecodecage.com/forumz/member.php?userid=1
(http://www.thecodecage.com/forumz/showthread.php?t=64614

--
Simon Lloy

Regards,
Simon Lloyd
'The Code Cage' (http://www.thecodecage.com