Filter Pivot Table Items Based On Named Range

[excelakos]

Hi everyone.
I am looking for a solution to filter Pivot Tables Items (no matter where these are positioned? Some time they may be in the ROWS some other in FILTERS or COLUMNS)

Sheet 1 contains the data feeding the pivot (data in a named table)
Sheet 2 is where Pivot table is placed (More Pivots exist in this Sheet so i need macro to target only the wanted Pivot table)
Sheet 3 is where the named range exists

If feeder table does not include any of the values could we deal with it somehow? Other codes i have used just filter some other value not belonging in the set of values in the named range which is a problem cause user believes the result is valid etc

Could we have a pop up saying a message like "No Values To Be Filtered" or anything so the user understands what is going on?

Thank you in advance

[Lyncz92]

Hey Excelakos,

What maybe is an option to use is Inputbox. This is a really powerfull tool to let vba work with user input. If you add you workbook or codes i may be able to help you with it