Export Data from a closed workbook

Originally Posted by mamuka12

Hi Ford,

I did initially use the vlookup but the master file is huge and it takes 20-30 minutes to get the data displayed once the ID number cell is populated.

what did the formula look like that you tried?
I have tried this method before when teh data file was too large to work with