Excel help
Solved/Closed
Flashrunner
Posts
1
Registration date
Friday 17 January 2014
Status
Member
Last seen
17 January 2014
-
17 Jan 2014 à 07:49
TrowaD Posts 2921 Registration date Sunday 12 September 2010 Status Contributor Last seen 27 December 2022 - 20 Jan 2014 à 11:10
TrowaD Posts 2921 Registration date Sunday 12 September 2010 Status Contributor Last seen 27 December 2022 - 20 Jan 2014 à 11:10
Related:
- Excel help
- Excel mod apk for pc - Download - Spreadsheets
- Vat calculation excel - Guide
- Kernel for excel repair - Download - Backup and recovery
- Excel clear formatting - Guide
- Arrow keys not working in excel - Guide
1 response
TrowaD
Posts
2921
Registration date
Sunday 12 September 2010
Status
Contributor
Last seen
27 December 2022
555
20 Jan 2014 à 11:10
20 Jan 2014 à 11:10
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
