Tom:

Sorry about the misunderstanding

First the G's are not hard coded or entered by formula they are simply
typed
in the cells of column (P) the other Characters in column (P) are as
follows

R for red
B for blue
BR for brown
P for pink or Magenta
O for Orange

A for loop I have coded loops through column (P) and changes the entire
row
the color of the Character in column (P)

I need to pick out all the green rows and copy them to
another worksheet that is already in the workbook "Rolls to be Pulled"

Any help is appreciated
Thanks
Charles


--
mrdata
------------------------------------------------------------------------
mrdata's Profile: http://www.excelforum.com/member.php...o&userid=17899
View this thread: http://www.excelforum.com/showthread...hreadid=511536