How to create multiple worksheets from a list of cell values without VBA

Creating Worksheets from a List of Names

Creating multiple worksheets from a list of values is very easy and it could be created by multiple methods. In this article, we will explore ways of creating it by using the following method. Though manually creating worksheets will be very time-consuming and using some tricks could make easy the task.

The first step in creating the task is to list all the values that we wanted to name the worksheets.

list the names for the worksheet
list the names for the worksheet

After listing the name insert a pivot table by using the newly created list as data range. After inserting the pivot table put the name of worksheet column in pivot table Filter as illustrated in the … Continue Reading