referencing an HLOOKUP on another Workbook, Pasting Results on Active Workbook

Hi All,

I have a very hard macro that I am trying to figure out and I am breaking my head over it. I am not an expert at VBA. If someone can please help I would appreciate that so much. I will try my best to explain what I was assigned to do.

I have one Excel file, let's call it my "Main File" and another worksheet that will be saved in the same filepath but not opened when I am running this macro. Let's call this my "Data File".
The Main File looks like this...
002- DASHBOARD.PNG

The Data File looks like this...
002- DATASHEET.PNG

On the main file there are a lot of different columns with different information. What I want is to write a HLOOKUP or any fucntion you may know, that if there is a match in the "Code" column in the Main File with the Data File (I.e. there codes match up) than I need it to retrieve the "Contract Worker" name and paste it in column L of that coresponding row on the Main File.

The table array for the vlookup is Range("A1:AK1345")
The closed Data File path is "C:\Users\673157897\Documents\Pro Fees Dash Board\Copy of RBC_CWM_DHR_Details_Report___Thomson__A (Preview).xls"


Also I don't want the Data file to stay open, I want it to close when macro is done.

To recap: I need it to scan the Data File 'code' column and if it matches with any codes on the Main File, simply paste Contract Worker name in deisred place (column L) of that row, and close the DataFile.


Please help, I am on the verge of lossing it. I appreciate you taking your time for this your a great person!