Programming Help - evaluate, select and Past into new workbook
 

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 int
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 the
paste into a new workbook.

Please Hel

--
Chewy66
-----------------------------------------------------------------------
Chewy667's Profile: http://www.excelforum.com/member.php...fo&userid=1361
View this thread: http://www.excelforum.com/showthread.php?threadid=32019

Programming Help - evaluate, select and Past into new workbook
 

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

Programming Help - evaluate, select and Past into new workbook
 

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

Programming Help - evaluate, select and Past into new workbook
 

:) Thanks ! This is going to save me lots of time

--
Chewy66
-----------------------------------------------------------------------
Chewy667's Profile: http://www.excelforum.com/member.php...fo&userid=1361
View this thread: http://www.excelforum.com/showthread.php?threadid=32019