insert date in a column when information is entered in another column

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Let's say I have column A and I want to add a date so that I know what date someone updated column A. Is there anyway to add a date to the end of anything someone types, or should I make exel populate a date in column B when something is entered in column A. If so what is the argument??? help hel

Another question, If I have a columnA called status and the status changes to a particular value, is there a way to auto email , if the email address is in columnB
 
See

http://tinyurl.com/yf1c

there you'll find both a macro and a formula way

--

Regards,

Peo Sjoblom


Millie said:
Let's say I have column A and I want to add a date so that I know what
Click to expand...
date someone updated column A. Is there anyway to add a date to the end of
anything someone types, or should I make exel populate a date in column B
when something is entered in column A. If so what is the argument??? help
help
Another question, If I have a columnA called status and the status changes
Click to expand...
to a particular value, is there a way to auto email , if the email address
is in columnB
 
One way:

Put this in the worksheet code module (right-click on the worsheet
tab and choose view code):

Private Sub Worksheet_Change(ByVal Target As Excel.Range)
With Target
If .Count > 1 Then Exit Sub
If .Column = 1 Then ' Entry in column A
With .Offset(0, 1)
.NumberFormat = "dd mmm yyyy"
.Value = Date
End With
End If
End With
End Sub
 
why when i change the column to D does it quit working....example...i want the date to be in column e

----- J.E. McGimpsey wrote: ----

One way

Put this in the worksheet code module (right-click on the worsheet
tab and choose view code)

Private Sub Worksheet_Change(ByVal Target As Excel.Range
With Targe
If .Count > 1 Then Exit Su
If .Column = 1 Then ' Entry in column
With .Offset(0, 1
.NumberFormat = "dd mmm yyyy
.Value = Dat
End Wit
End I
End Wit
End Sub
 
Back
Top