Sep 02 2021 12:53 AM
Hi fellow Excellers!
Is there any way to edit the source data from a combined file?
My situation:
I have a folder with several excel workbooks with tables in the same format, and with the same tab name. Every day, a new file is added.
With Power Query I can easily combine all workbooks, by just importing and combining the folder where all workbooks are stored.
What I would like to do is to be able to edit the data in the combined "master"-file, and get it edited in the source file as well. Is that at all possible?
I'm not afraid of using more advanced features, including VBA.
Hope to hear from you!
Best regards,
Josefin
Sep 02 2021 10:27 PM
only the source file can be edited to update the power queried (query by folder) master file.
Sep 02 2021 10:46 PM
SolutionSep 16 2021 03:07 AM
Sep 02 2021 10:46 PM
Solution