I am trying to copy/paste a range of cells if a particular cell is equal to the cell below it.
In the attached file I am going for something like:
If B3 = B2, then copy C2:I2 , paste in C3:I3.
repeat all of the way down
I use the following code a good bit and have tried to manipulate it in different ways to get the desired result, but have not had any success. I realize this code below starts at the bottom and works up and I could do that as well if I sorted the attached spreadsheet by ascending column B, ascending column A (instead of descending as it is now)
thank you!![]()
Dim i, LastRow LastRow = Range("G" & Rows.Count).End(xlUp).Row For i = LastRow To 5 Step -1 If Cells(i, "G").Value = "0" Then Cells(i, "G").EntireRow.Delete End If Next
Bookmarks