Hi,
After deciding that this was impossible, an idea came to me while I was in the
shower.
See the attached. B2 and B3 have data, so C2 and C3 should show the data entry
date of 16 March 2011, no matter when the file is viewed.
If you enter data into B4, the current date should appear in C4,
let us be very patient, waiting for some one who
give a formula that can write a Constat_Date into a cell
On Mon, Mar 14, 2011 at 1:06 AM, Hems coolh...@gmail.com wrote:
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.
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)
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
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
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