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