Hi Leith,

I had another look and now I know why I'm having the run-time error as I have got the worksheet name wrong.

Now that I fixed the issue, the macro runs beautifully, however, it seems that it is a bit slow, everytime the "GetData" button is hit, it has to download the Data.xlsm file from the server which takes more than 30 sec. When comparing to the VLOOKUP which is slow the very 1st time but once the connection is established, it is very quick, only 10 sec or so for the subsequent search.

In changing the searching method, my aim is actually trying to improve the time required in returning the data, so if you know of any method that can give a faster lookup will be much appreciated.

Thanks again,
Monhw