Hi Chewy667

You can also use this Add-in if you want
http://www.rondebruin.nl/easyfilter.htm


--
Regards Ron de Bruin
http://www.rondebruin.nl


"Chewy667" wrote in message ...

I would like to create a macro that evaluates certain value in Column A.
If they are equal to a certain number or text then select and past into
a new workbook.


For Example :
UNIT Organization
02 110102000003
02 110102000004
02 110102000004
02 110102000004
03 110103000001
04 110104000300
04 110104000301
04 110104000302
04 110104000303
04 110104000304
05 110105000305
05 110105000305
05 110105000305
05 110105000305

I want the macro to select all the rows that have Unit = 02 and then
paste into a new workbook.

Please Help


--
Chewy667
------------------------------------------------------------------------
Chewy667's Profile: http://www.excelforum.com/member.php...o&userid=13618
View this thread: http://www.excelforum.com/showthread...hreadid=320191