I would like to have the current date entered in one column when data is entered in the next column. Wondering if this can be done without a macro. I've thought of using the now() function but the next day of use, yesterday's dates will update to today. I'm guessing I will have to write code, which is fine, but if there was an easier way, I'm all for it.
-
If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.
Automatic date when data entered in another field
- Thread starter cjmcma
- Start date
DRJ
MrExcel MVP
- Joined
- Feb 17, 2002
- Messages
- 3,853
Put this code in the worksheet code section for the worksheets you want this to work on.
Private Sub Worksheet_Change(ByVal Target As Range)
If Target.Column = 1 Then
Range("B" & Target.Row) = Date
Else
End If
End Sub
Target.column is the column you are entering data in. change as needed
Range("B") is the column where you want to put the date. Change as needed
Private Sub Worksheet_Change(ByVal Target As Range)
If Target.Column = 1 Then
Range("B" & Target.Row) = Date
Else
End If
End Sub
Target.column is the column you are entering data in. change as needed
Range("B") is the column where you want to put the date. Change as needed
Upvote
0
bosco_yip
Well-known Member
- Joined
- Dec 2, 2002
- Messages
- 1,947
- Office Version
- 2019
- Platform
- Windows
1) Say your data at column B2:B10
2) Enter formula in A2 and drag to A10
=IF(B2<>"",TODAY(),"")
3) After the first day work, you highlighted range of Column A cells with data in the side, then click Copy>> Paste special >> Value.
Hope can helps
Regards
Bosco
2) Enter formula in A2 and drag to A10
=IF(B2<>"",TODAY(),"")
3) After the first day work, you highlighted range of Column A cells with data in the side, then click Copy>> Paste special >> Value.
Hope can helps
Regards
Bosco
Upvote
0
Similar threads
