Related:
- Excel help
- Transfer data from one excel worksheet to another automatically - How-To - Excel
- How to change date format in excel to dd/mm/yyyy - How-To - Excel
- Excel @ in formula ✓ - Forum - Excel
- How to change author name in excel - How-To - Excel
- Number to words in excel without vba ✓ - Forum - Excel
1 reply
TrowaD
- Posts
- 2807
- Registration date
- Sunday September 12, 2010
- Status
- Moderator
- Last seen
- September 21, 2021
Hi Flashrunner,
Right-click on the sheets tab and select view code. Paste the following code in the big white field:
In the code "Columns("A:A")" refers to the column with amounts and "Range("B" & Target.Row)" refers to the column where you want the date to be inserted.
Change these 2 column references to match yours and test the code by entering an amount; the date should be automatically entered.
Best regards,
Trowa
Right-click on the sheets tab and select view code. Paste the following code in the big white field:
Private Sub Worksheet_Change(ByVal Target As Range)
If Intersect(Target, Columns("A:A")) Is Nothing Then Exit Sub
Range("B" & Target.Row).Value = Date
End Sub
In the code "Columns("A:A")" refers to the column with amounts and "Range("B" & Target.Row)" refers to the column where you want the date to be inserted.
Change these 2 column references to match yours and test the code by entering an amount; the date should be automatically entered.
Best regards,
Trowa
