Hello, I'm trying to figure out how to cut and paste an entire row to a certain sheet based on column I in sheet 1. If it contains the word newspaper it will then be transferred to the newspaper sheet. I have TV and radio as other categories. It will only search for rows that are not colored red...