Using a List to drive creation of a Worksheet

  • Thread starter Thread starter angrygreg
  • Start date Start date
A

angrygreg

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
 
Greg,

Before you look to create a big application, learn a bit more about the power of Pivot Tables. Try
double clicking on the Store1 cell within the pivot table. Then double click the 10/6/2006 cell.
Both will show extra detail. And best of all, double click on one of the data cells - that will
create a new worksheet with all the data that goes into the report. You can also easily chose which
stores to show, using the page field of the pivot table, if you drag the Store field to that area
when creating the pivot.

HTH,
Bernie
MS Excel MVP
 
Back
Top