Transfer rows to another sheet via color or letters of row

[Closed]
Report
Posts
1
Registration date
Monday August 7, 2017
Status
Member
Last seen
August 7, 2017
-
the Excel sheet has information pertaining to record numbers. I check numeric record from a database and see if they are correct. if the information is not correct i color the row and type in the type it is then i have to copy it to another sheet and it may take about 7 seconds i need to eliminate and improve this time by transferring the colored row to it's proper sheet and yet keeping it in the main sheet, the formula must handle 3 colors YELLOW, BLUE, RED,also i input data into the Column Called "TYPE" these are the types "DUP,RED HOLD,RED,MAIL". i save to main sheet every few minutes to insure i do not lose data during the course of the day, the transfer can be done at the save click or some other way. please let me know if this is possible
these are the colors pertaining to type
RED = RED HOLD AND RED
YELLOW = DUPS
blue = mail