Hi,

I've been using Mr J. Walkenbach's "trick" on how to create a "list" from a
"summary table" but that was with Office 2003 and I can't get it straight
with Office 2007.

This how I used to do it (with Office 2003):

1. Click inside the summary-table (matrix).
2. Pivot table, multiple consolidation range option (I can't find this with
Office 2007)
3. Choose "I will create page fields option"
4. Specify range in summary table
5. Remoe row and column fields-button
6. Click OK and double-click on the data-cell. Voila!

But - how to do this with Office 2007?

I can't find any option where I choose "Multiple Consolidation Range" and
then "I will create the page fields option.

Any help much appreciated!

Cheers,
Mikael