Excel VBA Introduction Part 58.23 - SQL for Excel Files - Merge Worksheets Side by Side
By Andrew Gould
Writing SQL for Excel with ADODB playlist • Excel VBA Writing SQL for Excel using...
VBA Working with Databases playlist • Excel VBA Working with Databases
Get files here https://www.wiseowl.co.uk/vba-macros/...
If you'd like to help fund Wise Owl's conversion of tea and biscuits into quality training videos you can join this channel to get access to perks:
/ @wiseowltutorials
Or you can click this link https://www.wiseowl.co.uk/donate?t=1 to make a donation. Thanks for watching!
This video shows you how to merge multiple worksheets using a combination of union queries and outer joins. You'll use a union query to create a master list of values to join on and use this query to populate a derived table subquery. You'll join other worksheets to the results of the subquery to produce a side-by-side merged set of results.
Chapters
00:00 Topic List
00:42 The Basic Setup
02:36 Joining Two Worksheets
04:42 Outer Joins
08:41 Creating a List of Genres with Union
10:13 Joining to a Derived Table Subquery
13:18 Replacing Nulls with Zero
14:56 Joining More Worksheets
16:47 Joining the Remaining Worksheets
21:30 Adding a Where Clause
22:47 Adding More Conditions
Visit www.wiseowl.co.uk for more online training resources in Microsoft Excel, Power BI, DAX, SQL Server, Reporting Services, Analysis Services, Integration Services, ASP.NET, C#, Visual Basic, Microsoft Access and more
Watch video Excel VBA Introduction Part 58.23 - SQL for Excel Files - Merge Worksheets Side by Side online without registration, duration hours minute second in high quality. This video was added by user WiseOwlTutorials 06 July 2021, don't forget to share it with your friends and acquaintances, it has been viewed on our site 2,793 once and liked it 61 people.