Wise Owl Answers - How do I sort tables on multiple sheets in Excel VBA?

By Andrew Gould 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! Download files here https://www.wiseowl.co.uk/vba-macros/... This video show you how to apply sorting to all the Excel tables in a workbook. You'll learn how to loop through the ListObjects collection on each worksheet in the workbook and how to use the Sort and SortField objects to apply sorting to each table. You'll also see how to use data validation to create a basic user interface which allows the user to control which column to sort the tables by. Chapters 00:00 The Question 01:36 Referring to a Table Object 02:47 Sorting a Single Table 05:01 Changing Sorting Options 07:05 Sorting All Tables on One Sheet 08:03 Sorting Tables on All Sheets 09:30 Creating a Drop Down List to Choose a Sort Column 10:51 Sorting by the Chosen Column Name 13:49 Choosing the Sort Order 16:19 Checking the User Selected a Value Visit https://www.wiseowl.co.uk for more online training resources in Microsoft Excel, Microsoft Power BI, DAX, VBA, Python, Visual C#, Microsoft SQL Server, SQL Server Reporting Services SSRS, SQL Server Integration Services SSIS, Microsoft Access and more!