| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Copy rows that meet a certain criteria
Is there a way to select all rows in a list that contain a "yes" in the
first column of that list? I want a macro to copy only those rows with a "yes" in the first column and paste those rows to another worksheet. |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Copy rows that meet a certain criteria
Columns("A:A").Select
Selection.AutoFilter Selection.AutoFilter Field:=1, Criteria1:="YES" Selection.Copy Sheets("Hoja2").Select ActiveSheet.Paste James wrote: Is there a way to select all rows in a list that contain a "yes" in the first column of that list? I want a macro to copy only those rows with a "yes" in the first column and paste those rows to another worksheet. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Counting characters in multiple rows when rows meet specific criteria | Excel Worksheet Functions | |||
| Selecting Rows that meet criteria | Excel Worksheet Functions | |||
| count rows that meet certain criteria | Excel Discussion (Misc queries) | |||
| How to copy rows that meet criteria to another sheet in Excel | Excel Worksheet Functions | |||
| Delete Rows where cells does not meet criteria | Excel Worksheet Functions | |||
![James[_40_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Linear Mode
