Check out
http://www.rondebruin.nl/easyfilter.htm

If you use 2007 post back


--

Regards Ron de Bruin
http://www.rondebruin.nl/tips.htm


"Jamal" wrote in message ...
Hi everyone,

I am trying to put together a tool that can can search, column by column,
for a certain background/fill color (yellow), and then copy/paste the
value/text in various columns of the same row for each instance of yellow
background colored cells, into another worksheet.

I think I know how the first part of this problem can be solved (searching
for and identifying the background color cells), but how can I code to
copy/paste the values in specific cells?