I'm using the following code and it does exactly what I need. Only issue: I have to drag from row 2 to 62,000 or more from several files several times a day. It became a big time consuming.

I need to do this via macro.

=IF(COUNTIF([external.xls]Sheet1!$A$1:$A$100000,A2),VLOOKUP(A2,[external.xls]Sheet1!$A$1:$Z$62000,2,FALSE),0)


Basically this code match the values in column A in both files and insert the value of the column B of the external file in a column specified in the working file. The column to insert the value is specified with the number you can see just before "FALSE".

Thank you in advance.