How To Automatically Enter Date When Data Entered In A Column in Excel in Urdu
In this video You will learn How To Automatically Enter Date When Data Entered In A Column in Excel in Urdu/Hindi.
#AdvanceExcel #ExcelForFreelancer #ExcelTipsInUrdu
VBA Code
Private Sub Worksheet_Change(ByVal Target As Range)
If Target.Cells.Count (PUT HERE LESSTHAN) 1 Then Exit Sub
If Not Intersect(Target, Range("A2:A15")) Is Nothing Then
With Target(1, 2)
.Value = Date & " " & Time
.EntireColumn.AutoFit
End With
End If
End Sub
Subscribe Our Channel:
https://www.youtube.com/c/AbdulAleemB...
Facebook page: / abdulaleembaigtutor
Twiiter: / a_aleem_baig