Forum Discussion
Sagar29061
Apr 26, 2024Copper Contributor
Pull data from another excel document
I have 2 excel documents (not work sheets). ABC.xls, PQR.xls and XYZ.xls. I want to automatically pull the data from ABC and PQR to XYZ. Is there any way? All three documents are saved in same sha...
JKPieterse
Apr 26, 2024Silver Contributor
If you are pulling similarly shaped data (for instance, a table in both files with the same columns), then you can use Data, Get Data, From File, From Folder to do this. See https://support.microsoft.com/en-us/office/import-data-from-a-folder-with-multiple-files-power-query-94b8023c-2e66-4f6b-8c78-6a00041c90e4