My friend had given me a problem in excel of copy row whenever the values changed to another sheet next available row.
I have come-up with this following code
Private Sub Worksheet_Change(ByVal Target As Range)
If Not Application.Intersect(Target, Target.ActiveSheet.Range("A1:D1")) Is Nothing Then
Application.EnableEvents = False
Application.ScreenUpdating = False
Application.EnableEvents = True
Dim lastrow As Long
lastrow = Sheets("Sheet2").Range("A65536").End(xlUp).Row + 1
Sheets("Sheet2").Range("A" & lastrow & ": D" & lastrow).Value = Sheets("Sheet1").Range("A1:D1").Value
Hope it will help you.
Please share your valuable comments and feedback to firstname.lastname@example.org
Please send your review and feedback to email@example.com
Hi all, Today, I'll explain how to uninstall completely the openjdk from the RedHat Enterprise Linux (RHEL) machine. Some of the sof...
bash: C:/Program: No such file or directory error solution in git bash with windows directory path having spacesHi friends, Today, I have come across a situation where I have to execute the gitbash on windows with linux commands. The escape charact...
Hi, One of my friend asked me about how we can check whether ping/network is active or not? He suggested that, if we have a shortcut comma...