Quickly Create Worksheets from a List in Excel | Create Multiple Tabs Automatically Based on a List

In this Microsoft Excel video tutorial I explain how to automatically create a worksheet for each item in a list. This can be done using a PivotTable.

🕰️Timestamps
00:00 Introduction
00:05 Create a PivotTable based on the list
00:35 Add your list to the Filter area
00:47 Show Report Filter Pages
01:19 Delete text at the top of each worksheet

#exceltutorial #exceltips

[michaelwiggins]

Mine just creates a sheet named "sheet1, sheet2, sheet3, etc" for each one.