How To Create Multiple Worksheets From A List Of Cell Values - Excel Tips and Tricks - video Dailymotion

RabiGurungXybernetics

Learn how to create multiple worksheets from a list of cell values.   Here are the steps.  1) Place cursor in any name  2) Insert -- Tables -- PivotTable  3) Existing Worksheet  4) For Location, select B1 (or any cell)  5) OK  6) Drag "My Friends" into Filters.  7) Select the new PivotTable  8) PivotTable Analyze -- PivotTable --- Options -- Show Report Filter Pages...  9) OK   how to create multiple worksheets from a list of cell values,how to create multiple worksheets from a list of cell values in excel,create sheets from a list in excel,create excel sheets from a list,create excel sheets from list,How To Create New Sheet From A List In Excel,create sheets from names,create excel sheets from names,excel sheets,  how to create multiple sheets in excel at once with different names,create multiple sheets in excel automatically,how to create multiple sheets in excel with same format,macro to create multiple worksheets from a master worksheet,how to create multiple sheets in excel from one sheet,how to create new sheets for each row in excel,how to create multiple worksheets from a list of cell values vba,create sheets from list excel vba,  how to create multiple sheets in excel from one sheet,how to create new sheets for each row in excel?,macro to create multiple worksheets from a master worksheet,creating worksheets from a list of names,how to create multiple sheets in excel with same format,create multiple sheets in excel automatically,  how to create a drop down list in excel from multiple sheets,how to create a list from same cells across multiple sheets in excel,how to create new sheets from a list in excel,

Transcript

00:00If you have to create multiple sheet for every person on my list here, I hope

00:05you're not gonna do this like plus and then create the first name and so on.

00:11This is time-consuming, laborious, and sometimes can lead to error. And if your

00:16data set is as big as mine, I've got 1,000 people here, it can be a bit

00:21challenging to do that one at a time. Let me show you a more productive way to do

00:25it. First and foremost of all, you're gonna select any name on your data set

00:29here and then you're gonna go to insert pivot table and then in here you're

00:35gonna click on existing worksheet. On under location, you're gonna select any

00:40cell in your spreadsheet. I'm gonna select say B1 here and click OK. Over here on

00:46the far right hand corner, you're gonna drag my friends which is here, my friends

00:51field into filter and now you've got yourself a pivot table. Next you're gonna

00:57select the newly created pivot table like that and then you're gonna go to pivot

01:02table analysis and if you look on the far top left hand corner of the screen,

01:06there's options under pivot table section here. You're gonna click on show report

01:11filter page. Once you click on it, a pop-up window will appear like this. Make

01:16sure you're selected as my friend if you have multiple fields. Next you're gonna click

01:21OK. As soon as you do that, what Excel does is that it starts creating all the

01:27sheet for everyone in your list and you can see everyone on my list now have a sheet.

How To Create Multiple Worksheets From A List Of Cell Values - Excel Tips and Tricks

Category

Transcript

Recommended