Hi Hemant,
I don't think there's a non-macro solution for this.
Regards - Dave.
From: coolh...@gmail.com
Date: Sun, 13 Mar 2011 23:36:21 +0530
Subject: Re: $$Excel-Macros$$ formula to add date in next column
To: excel-macros@googlegroups.com
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) <setiyowati.d...@gmail.com> wrote:
put this code into sheets' module
Private Sub Worksheet_Change(ByVal Target As Range)
' siti Vi <villagera.g...@gmail.com>
' 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 <coolh...@gmail.com> 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 excel-macros@googlegroups.com
<><><><><><><><><><><><><><><><><><><><><><>
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 excel-macros@googlegroups.com
<><><><><><><><><><><><><><><><><><><><><><>
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 excel-macros@googlegroups.com
<><><><><><><><><><><><><><><><><><><><><><>
Like our page on facebook , Just follow below link
http://www.facebook.com/discussexcel
