Forum Discussion
Rebecca965
Jan 04, 2019Copper Contributor
Querying information from multiple excel files into a single sheet
Hi Everyone, I am trying to pull certain relevant data from multiple excel files that are located in multiple places into a single sheet on a new excel file. The files are not located in the same...
Detlef_Lewin
Jan 04, 2019Silver Contributor
Rebecca965
Jan 04, 2019Copper Contributor
I did find the Power Query option on the internet when I was searching. I wasn't really sure how to do this when the files are all in different folders on the server. The examples I saw had all the excel files in a single folder.
- Detlef_LewinJan 04, 2019Silver Contributor
It is the same when importing a single file. You only you have to do it multiple times.