O
Obi-Wan Kenobi
Finally I have managed to build a search tool using Advance Filter, I
run well as a macro. I can search customer details by their membershi
numbers.
My question is there a way I can define the filter further e.g. I ca
input the membership and city details i.e. membership No. (123456) an
City (Nottingham) at the same time and use one button to run the macr
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 Su
run well as a macro. I can search customer details by their membershi
numbers.
My question is there a way I can define the filter further e.g. I ca
input the membership and city details i.e. membership No. (123456) an
City (Nottingham) at the same time and use one button to run the macr
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 Su