Pivot Table Output

  • Thread starter Thread starter ,
  • Start date Start date
?

,

I am trying to use a pivot table for data on my employees. So far so
good, but I would like to have the output per employee into different
tabs within the worksheet.

Can anyone push me into the right direction?

Thank you in advance.
 
Thank you.

The intent is actually to allow the different employees to pull up the
workbook and only look at their respective sheets. I was thinking there was
a way to have the output go to different worksheets within the workbook (or
different worksheets in a new workbook).
 
Following on from Debbies response.

"Otherwise, put the Employee name in the Page area of the PivotTable and
choose a name from the dropdown, to see only that employee's data."

If you do this you can then use the show pages option found on the Pivot
menu toolbar.
This will result in a separate tab been created for each employee, and the
name of the tab will be that employees name.
 
Back
Top