| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Get rows which match selection criteria
I have an external file with about 20,000 rows in it. Each row has 6
columns. I need to work with all the rows where Column C = 'Name'. There will be a maximum of 25 rows. If I were doing it manually, I'd turn on Autofilter, select my Name in Column C then copy the visible rows. What's the most efficient way to do this in a macro? Is it best to copy the cells into an array? If so, how? Thanks, Fred Please reply to newsgroup, not e-mail |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do I Remove Rows that match a criteria | Excel Discussion (Misc queries) | |||
| Count rows that match 3 sets of criteria? | Excel Worksheet Functions | |||
| How can I retrieve multiple rows that match one criteria, i.e. a d | Excel Worksheet Functions | |||
| How to get number of rows which match criteria | Excel Worksheet Functions | |||
| Copy Rows if Lookup Criteria Match | Excel Discussion (Misc queries) | |||
Threaded Mode
