Forum Discussion
Combine data from multiple excel workbooks in a folder into one master file
I use Office 365 Hello, Please note that I made few changes to the criteria and the files that correspond to the new changes. I need help with VBA code that need to perform the below: There...
alex_n Sounds like a job for Power Query. No VBA needed. The link below take you to a site that's a great place to start learning. When you come to section 9, you'll learn all about connecting to files in a folder.
Interesting! Never thought from this perspective. Will definitely give it a try and will let you know. Thanks.