These two macros are always ran together. (the ones together in the first window.)
This one selects all the chosen rows with certain states using column 7 and moves them all to a new sheet1.
MoveNonStatesToSheet1
This, of course, moves the rows back to the same workbook and appends to first...