Extract data using Advanced Filter

[PcMax]

Hi,

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


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
170

[Admin]

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.

[PcMax]

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

[Admin]

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 (http://www.erlandsendata.no/english/index.php?t=envbadac)

[PcMax]

Hi,

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

=B2=C2

To avoid unnecessary sequence to search for the same values
following examples link
Excel Advanced Filter Introduction (http://www.contextures.com/xladvfilter01.html)