Date in adjoining field

U

Unorganized

I am new at this. Any help would be appreciated!! I have a
spreadsheet with data in L2. When the data in L2 is changed, I would
like excel to automatically post today's date in K2. Thanks for your
help!!!!!!!!!

Keith Thompson
 
P

Paul B

put this in the worksheet code

Private Sub Worksheet_Change(ByVal Target As Excel.Range)
If Intersect(Target, Range("L2")) Is Nothing Then Exit Sub
With Target
.Offset(, -1).Value = Date
End With
End Sub

To put in this macro right click on the worksheet tab and view code, in the
window that opens paste this code, press Alt and Q to close this window and
go back to your workbook. If you are using excel 2000 or newer you may have
to change the macro security settings to get the macro to run.

--
Paul B
Always backup your data before trying something new
Please post any response to the newsgroups so others can benefit from it
Feedback on answers is always appreciated!
Using Excel 2000 & 97
** remove news from my email address to reply by email **
 
Top