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