Pivot Table/Separate Worksheet Question

[scampy74]

I am pulling a report of each employee in my company and their individual benefits. This in turn causes them to have multiple rows each, one for each benefit they are enrolled in.

I can pivot this data to make each employee on one row with their benefits broken down; however, now I have one other question. I need to pull the information from the pivot table and create a separate worksheet for each employee, in order to accurately track each employees individual benefit costs/pay period.

Anyone know of any formula/code that can be used to automatically pull each row from the pivot table and create a worksheet for that row?

Thanks in advance!

 

[CWatts]

Pivot tables have functionality built in that may work for you. First off, save your file.

Take and put the employee's name in the filter section.

You want to look for something that says "Show Report Filter Pages". In excel 2007 it's under the red PivotTable Tools tab in the first section under options.

I hope that helps you along with what you're trying to do.