Best research method  
Author Message
vwfusion





PostPosted: Tue Mar 28 05:41:10 CST 2006 Top

Excel >> Best research method

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

Excel501  
 
 
Pete_UK





PostPosted: Tue Mar 28 05:41:10 CST 2006 Top

Excel >> Best research method I think you will need to explain in a bit more detail exactly what it
is you want to do.

Pete