First, I apologize for what are probably newbie questions.  I'm trying
to get up to speed quickly on Analysis Service, Pivot Tables and Excel
and have about a week of experience thus far...

What I'd like to do is use the values specified in the Pivot Table
(which is backed by an Analysis Cube) to drive the creation of a
seperate sheet.

So if the Left columns (categories) on the pivot table looks like

Store1     10/06/2006
              10/08/2006
              10/19/2006
Store 3     10/09/2006
               10/11/2006

I need a worksheet that has

Store1 10/06/2006
<bunch of formulas>

Store2 10/08/2006
<bunch of formulas>

Basically a master detail report grouped on the categories selected in
the Pivot Table.

Can anyone give me some guidance as to what kind of Excel
features/functions I can use to get this created?  If I have to use VBA
to create the template, that's fine, but I can't rely on the folks
using the report to know VBA and would like to avoid supporting a VBA
based application in the future.

Thanks... Any help is greatly appreciated

Greg Akins
http://pghcodingdojo.org