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
[ Ссылка ]
[ Ссылка ]

свернуть