Hi ybu1106,
How about using a little VBA to move those selected columns one to the left? Here is the code to do it.
![]()
Sub MovePOLeftOne() Dim LastGRow As Double Dim RowCtr As Double LastGRow = Cells(Rows.Count, "G").End(xlUp).Row For RowCtr = 1 To LastGRow If Cells(RowCtr, "G") = "Planned Order" And Cells(RowCtr, "T") <> "" Then Range("I" & RowCtr & ":T" & RowCtr).Cut Destination:=Range("H" & RowCtr & ":S" & RowCtr) End If Next RowCtr End Sub
Bookmarks