How do I create a pivot table of the data in the “data” tab to where it then created a clickable pivot table, as exampled in “example pivot table” tab. Here it will search the columns (Estimator PM Mktg Assist Acct Rep EMS), and if a persons name is in the “row”, it counts as 1 towards that person.

Once I click on the name of the person, or number of “jobs”, it opens up an organized file full of just the jobs (rows) with their name on it. 

I have included 2 “organized data” sheets to show you what I’m looking for. If I click on “Daniel” or “Larry” on the pivot table, it would generate those organized sheets.

​How do I create a pivot table of the data in the “data” tab to where it then created a clickable pivot table, as exampled in “example pivot table” tab. Here it will search the columns (Estimator PM Mktg Assist Acct Rep EMS), and if a persons name is in the “row”, it counts as 1 towards that person. Once I click on the name of the person, or number of “jobs”, it opens up an organized file full of just the jobs (rows) with their name on it.  I have included 2 “organized data” sheets to show you what I’m looking for. If I click on “Daniel” or “Larry” on the pivot table, it would generate those organized sheets.  Read More

​