I have come up with a macro to obtain values from another closed workbook and add it the current workbook. The macro actually opens the closed workbook and add the info to the current workbook based on the table name.

My issue is if the macro can be sped up..the workbook with vlookup values have over 369,000 values... I am using a vlookup formula, but want to know if an Index/Match or dictionary lookup would work faster. Code is below.

Please Login or Register  to view this content.