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.
Bookmarks