Hi JLGWhiz,

Your code working only for the B2 in the example i had mentioned it for
the understanding.Ok to explain you further say ill always copy paste
the date in A:A and "APPT" OR DEAPPT" IN B:B and i need those outcome in
C:C always.
Sorry for not explaining them earlier.

Many thanks,

Raja


--
Raja
------------------------------------------------------------------------
Raja's Profile: http://www.thecodecage.com/forumz/member.php?userid=497
View this thread: http://www.thecodecage.com/forumz/sh...d.php?t=115205