| 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 |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Get rows which match selection criteria
What is the format of the external file - csv, fixed width, a database file?
Can you open it in excel and it separates into appropriate columns? If so, one obvious choice is to open it in excel, apply the autofilter and get you data. (using a macro of course). -- Regards, Tom Ogilvy "Fred Smith" wrote in message ... 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 |
| Reply |
| 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) | |||
Hybrid Mode
