Creating a macro that pulls rows by the color
I have a spreadsheet that has data and each row is color coded to reflect a
status. I would like to create a macro that groups each color category
together in a separate worksheet.
For instance: Blue = Under Development. I created a worksheet called "Under
Development" and instead of having to manually scroll through the entire
original worksheet and copy each Blue row, I want the macro to do it for me,
and insert these rows (according to color - in this case, BLUE) in the new
worksheet, "Under Development"
Can anyone help?
Thanks,
|