I'm trying to figure out a way to search Column Q for a red Cell. If it is Red then it will copy the entire row and paste it into the First available row in Sheet 2. It will then go back to Sheet 1 and delete that row that was just copied. Can anybody help me with this. Any help is appreciated.