| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
macro to copy cells that meet criteria (mattour)
Hi guys,
i would like a macro to do the following: i have a database with 2000 lines and 50 columns. the macro should copy all the rows that fulfill the criteria that the 37th column=1 , to a new worksheet. can anyone help me? thankx |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
macro to copy cells that meet criteria (mattour)
hi matthias
See http://www.rondebruin.nl/copy5.htm Or use EasyFilter http://www.rondebruin.nl/easyfilter.htm -- Regards Ron de Bruin http://www.rondebruin.nl "matthias" wrote in message ups.com... Hi guys, i would like a macro to do the following: i have a database with 2000 lines and 50 columns. the macro should copy all the rows that fulfill the criteria that the 37th column=1 , to a new worksheet. can anyone help me? thankx |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How to copy rows that meet criteria to another sheet in Excel | Excel Worksheet Functions | |||
| Can I sum #s in a cell if other cells meet a certain criteria? | Excel Discussion (Misc queries) | |||
| Sum Total # Of Cells That Meet Several Criteria | Excel Worksheet Functions | |||
| Adding cells that meet certain criteria | Excel Programming | |||
| Adding cells that meet certain criteria | Excel Programming | |||
Linear Mode
