| 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 |
| 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 | |||
Threaded Mode
