VBA code to vlookup between workbooks - 75 USD

- 10% Prepayment sent

I am looking for a macro to perform a lookup between 2 separate workbooks. The worksheets will have identical sheet names and layouts. One sheet (Source Data) will be part of a file that contains other tabs that will feed to certain columns in this sheet. The other file is a standalone file (Destination_Lookup Macro) that is used to upload and download data to Oracle. It is a specific file that is downloaded from Oracle for offline compensation planning allocation which had connectors to our Oracle system.

There 6 columns that need values to be looked up. I highlighted the column headers in yellow (AC, AJ, BJ, BK, BL BP). The lookup value in both sheets is column E (Employee Number).

I would like to have the maco reside in the standalone file --> Worksheet (Destination_Lookup Macro).xlsm

If possible, I would like the macro prompt the user to browse and select which folder - file to use as the "source" file. After the file is selected, the macro will use the sheet named "AP Salary Bonus Consulting Plan" as the source sheet for the lookups. Then the macro will then perform the lookups for the 6 columns based on the Employee Numbers (Col E). If the user prompt functionality is not doable, could we then hard code the source file location in the macro?

Hi Roy...The ID's will be the same but may not be in the same sort order.

On second thought, the ID's should be the same but for this case, let's not assume that will be the case.

OK...let's assume the ID's will be in the same order. I'll make sure that will be the case when it's used. Thank you!

Yes, let's do that. The sheet is typically defaulted to sort ascending order by Name (Col F). Can we do that or does it have to be sorted by ID (Col E)?

Thank you. I would use it. But is it possible to accomplish with lookups so that it can be done with having the sort order exactly the same. If it take more time to design, that would be OK with me.

Ok. I like the speed of this solution. I’ll take it.

Would you be willing to to try the looping solution as well? I would pay as a separate request if that works. I would like to present both options to my user for this process.

Thank you! I Appreciate you looking further into this. Have a great evening.

Thanks Roy. Let's go with your solution that's runs fast. I'd rather have the quicker solution.

I’m sorry Roy. I must not have communicated this well but I would like to have your solution without the looping and that works fast. As soon as it’s posted, I will test and send payment. Thank you following up.