Extract data using Advanced Filter

Hi,

I'm doing a search on 65000 rows and I wonder if there are alternatives CriteriaRange to the code posted.

Code:

---

Sub Test()
    Range("A2:C31").AdvancedFilter Action:=xlFilterCopy, CriteriaRange:=Range( _
        "A34:C44"), CopyToRange:=Range("A47:C47"), Unique:=False
End Sub

---

Here is an example of the criteria with the data to search
Attachment 170

Hi,

I don't see anything wrong on this method. Since the data set is huge,a better option would be export data into Access and fetch data using SQL query.

Hi,
(I was hoping you could fit the search criteria to improve the number equal to the number if ...)

One question, I can use Access with Excel 2003.
If you install Excel 2007 - 2010 on new PCs will be helpful to link to Access?
What conditions, I have to install Access

If the data set is huge, I would recommend Access rather than Excel.

See this link for some info regarding import data from Access via ADO.

Erlandsen Data Consulting

Hi,

Finding inspiration in the network are able to find how to use the filter method:

Code:

---

=B2=C2

---

To avoid unnecessary sequence to search for the same values
following examples link
Excel Advanced Filter Introduction