Vba code to compile specific details from different excel file to one file from folder

You can do this really quickly and easily with Power Query.

The following query returns all files in your folder, as a table, and applies a function query for each column returned:

Please Login or Register  to view this content.

The four function queries, to return your four columns are identical, apart from the cell referenced. Name them consistently with the function names used in the CombineFromFolder query.

Please Login or Register  to view this content.

Please Login or Register  to view this content.

Please Login or Register  to view this content.

Please Login or Register  to view this content.

Example workbook attached - just change the folder path in the CombineFromFolder query, then refresh. To update, simply refresh the query.

Hi Olly,

Thanks for the reply!

Actually i do not have power query install on my system.

Is it possible by macro.

I am using below code but it is not working.

Please Login or Register  to view this content.

Regards,

upa

I'd recommend installing Power Query, and learning the basics. It's SO MUCH better than VBA for doing this kind of data processing.

However - here's a VBA solution. It will be much slower than the Power Query version:

Please Login or Register  to view this content.

Happy to help. If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED. You can also Add Reputation to those who helped you. Thanks.