Forum Discussion
Combining multiple excel sheets into one excel file and updating it each time there are changes.
i have 5 excel workbooks with all the sheets named the same. what I want to do is combine the 5 excel files into one workbook with the sheets in each of the excel file file merged together with the s...
In general that's job for Power Query if you consider such option (your tag is VBA).
Hi, then is it possible to connect the sheets that are in each of the workbook together as mentioned in the query without the use of Power Query
- http://e.anyoupin.cn/EData/?p=tools.consolidate.consolidateshts/consolidateSheetsSkipRows
How about this online tool?
