I am a self-learning novice with excel and just started working with pivot tables.
I created a pivot table out of my source data (55,000 entries) over a one year period of time in order to identify the data based on those people part of a family and those who came in as individuals. Great...so my pivot table identified the group that came in based on counting those with the same last name for a given day.
Now, I need to compile the two groups into separate worksheets (including all of their orginal source data). The only way I have found to show the details of the data is by double clicking on the cell and a new worksheet opens for that individual. I then have to copy and paste into a new master worksheet.
I am looking for a way to show the data for all the cells in my pivot table at the same time so I don't have to open each one individually.
I put a conditional format on my pivot table (count of last name = greater than or equal to 2) so I can't "show" the cell contents of my individually summed totals for each day because it includes individuals not specified by my conditional formatting.
Does anyone have a suggestion on how to work around this? I am sure it is possible as anything is possible in Excel... I am just stuck.
Thanks for the help.
I created a pivot table out of my source data (55,000 entries) over a one year period of time in order to identify the data based on those people part of a family and those who came in as individuals. Great...so my pivot table identified the group that came in based on counting those with the same last name for a given day.
Now, I need to compile the two groups into separate worksheets (including all of their orginal source data). The only way I have found to show the details of the data is by double clicking on the cell and a new worksheet opens for that individual. I then have to copy and paste into a new master worksheet.
I am looking for a way to show the data for all the cells in my pivot table at the same time so I don't have to open each one individually.
I put a conditional format on my pivot table (count of last name = greater than or equal to 2) so I can't "show" the cell contents of my individually summed totals for each day because it includes individuals not specified by my conditional formatting.
Does anyone have a suggestion on how to work around this? I am sure it is possible as anything is possible in Excel... I am just stuck.
Thanks for the help.