Excel VBA - Search record with multiple criteria
 

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!

--
Message posted from http://www.ExcelForum.com

Excel VBA - Search record with multiple criteria
 

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

--
Message posted from http://www.ExcelForum.com

Excel VBA - Search record with multiple criteria
 

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

--
Message posted from http://www.ExcelForum.com