Hey STDEV(i), Thanks a lot but i dont want macro, i want formula for it.
Let me know if is there any formula for this. Regards, Hemant On Sun, Mar 13, 2011 at 1:04 PM, STDEV(i) <[email protected]> wrote: > put this code into sheets' module > > Private Sub Worksheet_Change(ByVal Target As Range) > ' siti Vi <[email protected]> > ' jakarta, 11 mar 2011 > '------------------------ > If Target.Count = 1 Then > If Target.Column = 1 Then > If Target.Row > 1 Then > If Len(Target) > 0 Then > Target(1, 2) = Date > End If > End If > End If > End If > End Sub > > > > On Sun, Mar 13, 2011 at 1:53 AM, Hems <[email protected]> wrote: > >> Dear All, >> >> I want today's date in next column (column B) on the day when first >> column ( column A) was updated. >> for Ex. if A3 was updated on 14th Mar'11 then B3 should display that date. >> If i open this file on 16th Mar'11 then also B3 should display 14th Mar'11 >> and not 16th Mar'11. >> >> Appreciate i get formula for this issue rather then macro. >> >> >> Thanks in advance >> >> Kind Regards, >> Hemant > > -- > > ---------------------------------------------------------------------------------- > Some important links for excel users: > 1. Follow us on TWITTER for tips tricks and links : > http://twitter.com/exceldailytip > 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 > 3. Excel tutorials at http://www.excel-macros.blogspot.com > 4. Learn VBA Macros at http://www.quickvba.blogspot.com > 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com > > To post to this group, send email to [email protected] > > <><><><><><><><><><><><><><><><><><><><><><> > Like our page on facebook , Just follow below link > http://www.facebook.com/discussexcel > " -- ---------------------------------------------------------------------------------- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to [email protected] <><><><><><><><><><><><><><><><><><><><><><> Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel
