how can i find 2 cells at the same time. like i want to
search if Cell in column "A" has "Singpaore" and Cell in
column "B" has "MAL"
if several agreements to be searched you can use the Advanced Filter in
Data | Filter | Advanced Filter.
Your List range incl. headings is maybe in A1:B50.
Then write e.g. within the range D1:E2 the headings and the filter criteria.
You can filter in same place or copy the result to another place.
Record this action with the Macro recorder, in order to receive the syntax for the VBA code.
--
Regards
Melanie Breden
- Microsoft MVP für Excel -
http://excel.codebooks.de (Das Excel-VBA Codebook)