Hi Don...

well, it could be possible depending on how you define several "words" in your post.

You could for example create all the necessary PivotTables and display them with a "foto" taken with the Excel camera. That at least was the first solution that came into my mind. You can then dynamically change the photos of the displayed PivotTables based on the value in G20.

I'm not sure if it is possible to "dynamically re-create" a PivotTable each time based on the given value though (which I think is your initial approach).

Let me know, if this would help you and I explain it in more detail.

Best,

Phil

Ummm, excel camera?

You can learn about the Excel Camera tool here.

Interesting to learn about the camera tool =)

DonW wrote: "..................I can't provide a working sample. However, I can provide a diagram (in the word document attached)..............."

I'm sorry, but couldn't find the Word document attached? (there seems to be an issue with an extra button you have to push for uploading files)

Hi DonW

I would suggest creating a Pivot Table with your Table names and use a slicer to select it instead of using data validation.

Based on what you select, display your list using the camera tool as suggested by Phil.

I normally use this method to allow users to select charts to display on their dashboards.

Sunny Kow

Mynda Treacy said
You can learn about the Excel Camera tool here.  

Thank you Mynda 🙂

SunnyKow said
Hi DonW

I would suggest creating a Pivot Table with your Table names and use a slicer to select it instead of using data validation.

Based on what you select, display your list using the camera tool as suggested by Phil.

I normally use this method to allow users to select charts to display on their dashboards.

Sunny Kow  

Thank you SunnyKow. I'll put that to use whenever my company upgrades from version 2007.

Phil Kowalski said
Hi Don...

well, it could be possible depending on how you define several "words" in your post.

You could for example create all the necessary PivotTables and display them with a "foto" taken with the Excel camera. That at least was the first solution that came into my mind. You can then dynamically change the photos of the displayed PivotTables based on the value in G20.

I'm not sure if it is possible to "dynamically re-create" a PivotTable each time based on the given value though (which I think is your initial approach).

Let me know, if this would help you and I explain it in more detail.

Best,

Phil  

Thanks Phil.

When I return to work next week, I'll look in to that..........The managers are drastically changing our database (quickbase) which means I will have a lot of work updating all of my reports to match the new version, ick............

Frans Visser said
DonW wrote: "..................I can't provide a working sample. However, I can provide a diagram (in the word document attached)..............."

I'm sorry, but couldn't find the Word document attached? (there seems to be an issue with an extra button you have to push for uploading files)  

Frans Visser:

To give an overview, my manager rpt tab shows the

manager name as a data validation,

a dynamic list of programs based on the manager name selection with overall scores for each program.

Below that, is a formula to display the top producing (score) program and then the bottom producing program. These can change each week (when the report is run). Within the top producing program area, is a section for the top 3 and bottom 3 sales people. Below that, is the Bottom producing program and again, the top 3 and bottom 3 sales people. It's in these areas where I was attempting to display 4 pivot tables, one for the each of the top 3 and bottom 3 sales people.

Current Excel version is 2007.