I show 3 techniques for combining / consolidating the data from an Excel file
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
Download the files I used
[ Ссылка ]
Subscribe
[ Ссылка ]
Connect with me
[ Ссылка ]
[ Ссылка ]
