Forum Discussion
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...
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