perhaps
Dim i As Long
Dim j As Long
'Move piece counts to job information row
For i = 1 To 100
If Range("A" & i).Value <> "" Then
If Range("E" & i).Value <> "" Then Range("G" & i).Resize(, 4).Value = Range("G" & i + 1).Resize(, 4).Value
End If
Next i
'Delete Rows with a blank cell in columnE
Range("E1:E" & Cells(Rows.Count, "E").End(xlUp).Row).SpecialCells(xlCellTypeBlanks).EntireRow.Delete
'Move Order ammount up to same line as job information
For j = 100 To 1 Step -1
If Range("A" & j).Value = "" Then
If Range("B" & j).Value = "" Then
' already deleted blank cells in E
' If Range("E" & j).Value <> "" Then
Range("E" & j - 1).Value = Range("E" & j).Value
Range("E" & j).EntireRow.Delete
' End If
End If
End If
Next j
Bookmarks