Multiple Files Merged and Repeated macros

hi guys, i have been tried this code in order to grab the data,
but it keeps me waiting and waiting.

i have been tried a small amount of data, and it did work. but not the large amount of data.

For example:
i have unlimited rows and 15 columns of data,
and i have to vlookup the information into another sheet based on some criteria,
i have been tried to use relative reference to repeat the vlookup with using macro, but seems have to input more codes.


Any possible solution to extract data from multiple excel files and to do repeated vlookups, hope i can use macro to repeat the jobs for me.
Thank you so much for your time.

Please Login or Register  to view this content.

Hi,

I have seen your both files but here you can simply use any lookup function...
If you want to lookup function then you must keep all the files in a order..
You are use VBA code for this but again you have to manually open the file.....I would suggest you if you already know the file path then it is better to use lookup.......if is too monotonous for you then I can try to build the code.......