Use the Autofilter on the Unit column. Then select the data and copy. Only
the visible rows will be copied

Turn on the macro recorder while you do it manually and you will have your
code.

--
Regards,
Tom Ogilvy

"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