Hi jensand,

If you have a Page Field you can use the 'Show Pages' item in the Pivot
Table menu to create multiple sheets, each with a pivot table for each item
in the Page Field.

Go to http://www.edferrero.com/ExcelTutori...4/Default.aspx for a
Pivot Table tutorial.

Ed Ferrero
www.edferrero.com


"jensand" wrote in message
...
Is there a way to show the detail for multiple cells in one step?
Preferably
with each being on a separate sheet.

Thanks!