EXCEL Pivot Tables

hbillsmith wrote:
I'll try to answer. I spend most of my days doing nothing but pivot tables. I'm not sure I understand your example though. Assume that with the workbook open, you working in the worksheet/tab that has the master data file. Select the menu option to 'Insert Pivot Table' (that's where it is in the current version of Excel). In older versions, it was under the menu option for Data. Once you find the Insert Pivot Table, you'll see the familiar dialog that let's you put your table to appear in the same worksheet (you don't want that) or to have it be on a new worksheet. Choose new worksheet and it will put the initial pivot on a new tab. Keep going back to the master data and re-running Insert Pivot until you have created as many Pivot tabs as you like. Then one-by-one, go to a Pivot tab, right-click on the tab name and give it whatever name you want. While on the tab, manipulate the pivot fields to get the view you are looking for.
Hopes this helps.

Thanks for responding but I was able to do it with some type of Populate Workbook command last time. Once I enter whatever the command was, it rapidly created 100 new worksheets each with the correct individuals name on the tab. I've tried looking at the EXCEL help files for Pivot Tables but without knowing what they called the command, I'm coming up empty. I understand your posted reply but I simply don't have the time to create 100 individual pivot tables