Thanks a lot Tushar.

But I wasn't sure If I could use SQL queries in Excel. Anyway, is it faster
to use sql than index & match ?

Thanks in advance.

"Tushar Mehta" a écrit dans
le message de news: ...
Since you mentioned SQL in the subject line why not use it? If your
data are in tables that is a perfectly feasible approach. For an
introduction on getting Excel (and MS Query) to do the heavy lifting,
see
Building and using a relational database in Excel (with a little help
from MS Query)
http://www.tushar-mehta.com/excel/ne...cel/index.html

In article ,
says...
Hello,

I have a big excel sheet (more than 50Mb) and I need to get data out of
this
big file as fast as I can. At the moment, I use the function index with
match but it's taking a lot of time.

Is there any other way thru vba or else to get the data alot more faster?

Thanks in advance.

Nader