Best research method

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
I think you will need to explain in a bit more detail exactly what it
is you want to do.

Pete
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Data selection from one worksheet into a second worksheet. 1
Figuring out a lengthy formula. Probably quite simple... 3
Auto data entry 2
***Help on writing a vba code 12
LOOKUP but with 2 parameters ? 1
Copy unique values problem 5
More Rows/One Sheet vs More Sheets/Less Rows for best performance? 1
Arrays containing variable sheets 2

Back
Top