move cells to other sheet(s) based on color

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

ok, I've been able to get the color index for cells and sum only certain colored cells, but what I really is a function to move a row to another sheet once I make that row a certain color. I'm new to VBA, but I was able to insert some functions from a webpage for the color index and sumbycolor, so if you know how to create the function I need, that would be great
 
It would also be great to have the rows delete (or hide) on sheet 1 when they are moved to another sheet so that I'm not left with a bunch of blank rows on sheet 1 (or on the new sheet either, if that's possible).
 
Back
Top