I am trying to copy rows based on color (which is listed in one of the columns) and paste that data into a worksheet named that specific color (ex: copy all data that is blue and paste it into a worksheet called Blue). I already have a macro that creates all the accompanying worksheets, I just can't figure out how to copy and paste rows based on the values in one column to the matching worksheet.
There are multiple rows for each color.