Hi to @ll,


I have a one querry if any one can solve it I will be very thankful. my querry is that i have a file containing name of co., month statemnt received, stamped & date (on which the statement is received). what i want is that when i write yes in B coloumn of particular co. let say.A Co. which is in cell A6 so that the (yes written in B6) then in cell D6 it should get automatically today's date. I have tried one formula in D coloumn (i.e. if(cell="yes",today(),""), here cell means cell of B coloumn's cell no.). But the problem is that when I open the file next day it recalculate the formula and the date gets change to today's date
(in D coloumn ) where i have mention yes in coloumn B. If any one can write macro in such a way that when i open the file it should not recalculate the formula to those cell of D coloumn which had already returned the date in accordance with the detail in B coloumn.

Attached Files

sample file.xls (22.0 KB, 16 views)