View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Aria Aria is offline
external usenet poster
 
Posts: 5
Default 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,