filter a column in pivot table with data in a column of other sheet!

[hoomantt]

Hi Dear Professors

Is there any way to filter a pivot table with all of data in a column?

Foe ex. In the attached file I have a macro that filter a column and set all data after filtering in the (“main”) Sheet.

Now I want to filter the pivot table column A in (“sheet1”) with the data there are in( column I ) in the (“main”) Sheet .

Is There Any Way ?!

Thanks a lot

i can not attach file here there for i upload it in this address :
http://s5.picofile.com/d/aa9c3ef9-1588-4d8b-9c3c-88c91a9d8db0/e.xlsb

 

[jeffreyweir]

Yes there is...I wrote some code recently that does just this:
http://dailydoseofexcel.com/archives/2013/11/14/filtering-pivots-based-on-external-ranges/