Hai
i am using excel 2007 and i have a doubt in using show details in pivot table

i am having a data with names and amounts
i had created a pivot table with names in row lables and amounts in values

by double clicking on a cell under values details of amounts are shown in a new worksheet

my doubt is
what should i do so that all the individual names are opened in different worksheets instead of double clicking on every cell individually

regards

Bala