Forum Discussion
Need help in merging excel worksheets from different workbooks
Hi all I want to merge worksheets from different workbooks, but I cant merge more than two sheets into a master file if the name of the sheets are same. How do I go about this? Example: I've ...
If you struggle replicating the process have a look to https://answers.microsoft.com/en-us/msoffice/forum/all/power-query-get-transform-combine-all-or-selected/94f0b4d1-3e05-4f07-850c-1350804403f5 (inc. a workbook template that does what you want after enterring a few parameters)