Best research method

M

Maileen

Hi,

I have 2 sheets in excel with around 20.000 records each.
I would like to research on "sheet A" if data on "Sheet B" exists.
for that i want to use 3 criteria from sheet B and search in sheet A.

if found, i will do something from sheet B to Sheet A.

i tried to use autofilter but it is very slow method for 20.000 records. i
tried also to scan 1 by 1 but it is worse...

Have you got some idea how can i speed up this research ?

thanks a lot,
Maileen
 
P

Pete_UK

I think you will need to explain in a bit more detail exactly what it
is you want to do.

Pete
 
Top