View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Jim Thomlinson Jim Thomlinson is offline
external usenet poster
 
Posts: 5,939
Default Auto enter date when data in enter in another cell

If you are not adverse to VBA macros this is fairly easy to do. Otherwise you
are going to have to rely on the person entering the data to add the date
manually. it is quick and easy to add the current date using
Ctrl + ;
If you want the code solution here it is
Right Click the Tab where you want the dates added and select View Code.
Paste the following...

Private Sub Worksheet_Change(ByVal Target As Range)
If Target.Column = 2 Then Target.Offset(0, -1).Value = Now()
End Sub

This code adds both date and time. If you only want to see the date just
reformat the column to only show the date.
--
HTH...

Jim Thomlinson


"Brian" wrote:

Howdy All,

I want the date enter in column A when data in enter in column B.
I want this date to remain constant, meaning that once it is enter as
12/4/2006, that it will not change.

Thanks,
Brian