Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
programming to select rows based on condition | Excel Discussion (Misc queries) | |||
How to evaluate the size of each worksheet in a workbook? | Excel Discussion (Misc queries) | |||
Challenge - evaluate and select | Excel Discussion (Misc queries) | |||
Past the total of select multi row data | Excel Discussion (Misc queries) | |||
programming font color on select items | Excel Programming |