This is below isn't working. I tried to find Account total and then copy everything from that row in between column "D:H" then transfer it to range c27 in sheet "AR SUMMARY". It doesn't seem to do anything. Is there a solution for this?
Code:
Sub transfering_Rental()Sheets("Space Rental").Activate
Set Sht = ActiveWorkbook.ActiveSheet
nlast = Cells(Rows.Count, "A").End(xlUp).Row
For n = nlast To 1 Step -1
If Sht.Cells(n, 2).Value = "ACCOUNT TOTAL" Then
Sht.Rows(n).Range("D:H" & n).Copy
Sheets("AR SUMMARY").Range("C27" & n).PasteSpecial xlPasteValues
End If
Next n
End Sub