Finally I have managed to build a search tool using Advance Filter, It
run well as a macro. I can search customer details by their membership
numbers.

My question is there a way I can define the filter further e.g. I can
input the membership and city details i.e. membership No. (123456) and
City (Nottingham) at the same time and use one button to run the macro
for the search. The code below only lets me put in one search

Sub search2()
'
' search2 Macro
' Macro recorded 22/03/2006 by s
'

'
Range("A10").Select
Range("A10:A25").AdvancedFilter Action:=xlFilterInPlace,
CriteriaRange:= _
Range("A1:A2"), Unique:=False
End Sub


--
Obi-Wan Kenobi
------------------------------------------------------------------------
Obi-Wan Kenobi's Profile: http://www.excelforum.com/member.php...o&userid=32578
View this thread: http://www.excelforum.com/showthread...hreadid=525404

What do you have in A2?


--

Regards,

Peo Sjoblom


"Obi-Wan Kenobi"
wrote in
message ...

Finally I have managed to build a search tool using Advance Filter, It
run well as a macro. I can search customer details by their membership
numbers.

My question is there a way I can define the filter further e.g. I can
input the membership and city details i.e. membership No. (123456) and
City (Nottingham) at the same time and use one button to run the macro
for the search. The code below only lets me put in one search

Sub search2()
'
' search2 Macro
' Macro recorded 22/03/2006 by s
'

'
Range("A10").Select
Range("A10:A25").AdvancedFilter Action:=xlFilterInPlace,
CriteriaRange:= _
Range("A1:A2"), Unique:=False
End Sub


--
Obi-Wan Kenobi
------------------------------------------------------------------------
Obi-Wan Kenobi's Profile:
http://www.excelforum.com/member.php...o&userid=32578
View this thread: http://www.excelforum.com/showthread...hreadid=525404

A2 is the search field, I type in what I am searching for and it filters
it from the spreadsheet which starts from A10.

A1 is the title of the search field e.g membership no.
A2 is were I type in the number e.g. 123456

A10 is the start of the spreadsheet from with the membership number is
filterd from


--
Obi-Wan Kenobi
------------------------------------------------------------------------
Obi-Wan Kenobi's Profile: http://www.excelforum.com/member.php...o&userid=32578
View this thread: http://www.excelforum.com/showthread...hreadid=525404

Then you need to use 4 cells instead of 2, in A1 membership no. in B1 city
in A2 12345 in B2 Nottingham

then in the macro

CriteriaRange:= _
Range("A1:B2"), Unique:=False



--

Regards,

Peo Sjoblom





"Obi-Wan Kenobi"
wrote in
message ...

A2 is the search field, I type in what I am searching for and it filters
it from the spreadsheet which starts from A10.

A1 is the title of the search field e.g membership no.
A2 is were I type in the number e.g. 123456

A10 is the start of the spreadsheet from with the membership number is
filterd from


--
Obi-Wan Kenobi
------------------------------------------------------------------------
Obi-Wan Kenobi's Profile:
http://www.excelforum.com/member.php...o&userid=32578
View this thread: http://www.excelforum.com/showthread...hreadid=525404