Is it possible to link two pivot tables to the same drop down filter

**ggremel** · 05-01-2011, 07:55 PM

I have one pivot that is look up the division AA. I have another pivot table looking up the same source. I would like to set it where if one pivot table looks at division AA, both will.

Thoughts.

**alansidman** · 05-01-2011, 08:11 PM

Is this what you are trying to do?

http://www.datapigtechnologies.com/f...s/pivot10.html

Alan

**ggremel** · 05-15-2011, 05:47 PM

perfect! Thank you for the link. Simplicity in action.

**Padre5** · 05-23-2014, 12:26 PM

This is exactly what I'm trying to do but with just on PT.

I've followed along in the above suggested tutorial and have came up with the below code but it's not working and was hoping someone take a look at the code and tell me where I've went wrong? (I'm not much of a coder but was able to follow along in that awesome video)

The only difference with my spreadsheet is my combo box is on one sheet. The PT is on another sheet. and the Index formula is on it's own sheet and I think maybe that's where my hang up is? I recorded the macro on the PT sheet like in the tutorial but for some reason I"m not able to get it to work. Thank so much in advance if anyone is able to help.

Please Login or Register  to view this content.

Index formula is on a sheet named Analysis and in cell C3 - Analysis!C3
PT is on a sheet named "PT"
Combo box is on a sheet named "Dashboard"

**alansidman** · 05-23-2014, 02:13 PM

Unfortunately your post does not comply with Rule 2 of our Forum RULES. Do not post a question in the thread of another member -- start your own thread.

If you feel an existing thread is particularly relevant to your need, provide a link to the other thread in your new thread.

Old threads are often only monitored by the original participants. New threads not only open you up to all possible participants again, they typically get faster response, too.