- 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?