Get rows which match selection criteria

  • Thread starter Thread starter Fred Smith
  • Start date Start date
F

Fred Smith

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
 
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).
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Eliminate blanks while copy row and transpose 11
Select rows with visible data 0
Array with many cells from a row but not in order or together 11
Cutting row data and pasting into next available row on different tab 2
How to set range to autofiltered visible cells? 7
Excel Help to copy information from one row at a time to another sheet 1
VBA CreateNames (ignores last 5 rows?) 6
My Never ending ARRAY code problems 18

Back
Top