Excel VBA - Search record with multiple criteria

[CathG]

Hi,

Can somehow tell me how to search for a record if I have a database i
excel that I need to firstly specify my criteria in say, column A, the
to serch within the filtered records from my previous search and loo
for another particular group of records, then further to serach agai
from the narrowed list for a signle line? it will be helpful if I ca
prompt up dialogue box to to ask for the search criteria.

Million thanks for the help!

 

[duane]

would using autofilter do the trick? Just keep filtering successiv
columns to get the one you want

 

[CathG]

Yes!! Thanks so much! I was blinded with the available options whe
someone ask me to do the macro