You would need VBA code to do that, would you be comfortable with
that?##Rebecca;231282 Wrote:
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.
--
Thanks Becky
--
Simon Lloyd
Regards,
Simon Lloyd
'The Code Cage' (
http://www.thecodecage.com)
------------------------------------------------------------------------
Simon Lloyd's Profile:
http://www.thecodecage.com/forumz/member.php?userid=1
View this thread:
http://www.thecodecage.com/forumz/sh...ad.php?t=64614