copy rows based on cell colour

  • Thread starter Thread starter K
  • Start date Start date
K

K

Hi, can anybody please able to tell me the macro that how can i copy
rows to another sheet on based on cell colour. Like if i have
"Interior.Colorindex = 3" or Red in cell B1,B3 and B7 so how can i
copy those colored rows which should be not entire row but from Cell A
to Cell F in length to any other sheet. Please anybody can help it
will be very helpful.... Thanks
 
Back
Top