Forum Discussion
Solved
Using Query and Connections
Is it possible to pull data from multiple Excel files in a folder using one Query and populate one worksheet with data from each of the Excel files. Thanks.
Hello,
don't give up so fast. Click Data ribbon > Get Data > From File > From Folder, then navigate to the desired folder.
Hello,
don't give up so fast. Click Data ribbon > Get Data > From File > From Folder, then navigate to the desired folder.
Thank you Ingeborg and Tanya. You were both very helpful. This is going to save me a ton of time in my analyses.