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...
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...
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...