I'm sure that this has been covered before but I can't seem to find it. I want a macro that will copy an entire row from one sheet to another based on the fill color of one cell. Since I will be continually adding to the main sheet this will need to copy to the next empty row when it runs.
In my sample attachment, if the cell is green I want the row copied to the "Good" sheet and if it is red to the "Bad" Sheet.
Thanks for any help.
Steve
Bookmarks