Combine Excel Sheets - Automatically!
Wyn Hopkins
![Wyn Hopkins]()
Wyn Hopkins
Leading a team that solves data challenges for companies and people Power BI | Excel | Fabric | Solver Budgeting & Consolidation. Control costs, reduce risk and assist growth Microsoft MVP ??5 Million+ YouTube views
Connecting to an Excel file on OneDrive or SharePoint and then use a sneaky hidden trick to combine all sheets into one reporting table using Power Query
Time Stamps:
00:00 Intro
02:21 Connect to a SharePoint file
03:45 The trick to consolidating dynamically
04:23 Consolidate Tables - Difficulty - Easy
06:21 Consolidate Sheets - Difficulty - Medium
10:50 Using a Custom Function if your data is messier - Difficulty - Hard
Extra info
Here's the file if you want to play along
Senior Finance Manager | Ex. Heidelberg Material | IFRS Expert | Cost Management | FP&A | SAP | Oracle | ERP implementation
2 年Easy way as usual Thanks Wyn Hopkins
I do Cash and Liquidity Management | Credit and Financial Analyst | Treasury Manager
2 年Great tricks, Wyn. I love the first two tricks but would need to practice the third trick more. Thank you for sharing.