If "On PTO", Column AF any cell 23 thru 35 = True, copy Cell A23 and Cell AC23 and paste to Sheet "<1 YR Not PTO", Cell A5 and Cell B5 if empty otherwise next empty row. I then want to clear content on Sheet "On PTO" in Cells A:Z of the row that held True, but keep formulas in place for new...
Let's say I have a list with orders with every row has seller ID and a product serial nr
So it could be (the name and serial nr are different cells)
So in another sheet I have
John 2 1