I have a spreadsheet where column "S" has a PO #, and column "V" has a received status. What I'm looking to do is the following:
If column "V" has an "R" (received), then it goes to column "S" to check the PO, and compares that to all of the PO #'s in column "S". If all of the rows with the matching PO have been received, it takes all of those rows, cuts them, and puts them to another sheet (so I can go back and reference down the line). It will also delete the now empty rows.
If column "V" has an "R" (received), then it goes to column "S" to check the PO, and compares that to all of the PO #'s in column "S". If all of the rows with the matching PO have been received, it takes all of those rows, cuts them, and puts them to another sheet (so I can go back and reference down the line). It will also delete the now empty rows.