I'm looking for someone to help me edit this code some. I need it to look in column "F" and find cells which say <####> and "Total" (IE a subtotal row). If it finds that, then offset one cell to the left and copy the cell that is directly above it.
Thanks!![]()
Sub Test() Dim lngrow as long lngRow = Range("I4").End(xlDown).Row Do While lngRow > 0 If Cells(lngRow, 6).Value Like "*Total" Then ActiveCell.Offset(-1, 0).Select Selection.FillDown End If lngRow = lngRow - 1 Loop End Sub
Bookmarks