[SOLVED] Drop down control pivot table but NOT overwrite value if not found

I have a drop down that, when an item is selected, it selects that same item in the pivot table filter

However, sometimes, that item is not there for a particular month.

I need to locate the item in the pivot table filter and if it's not there, I don't want it to overwrite the name of the item in the pivot, I want it to display a message 'Selection not found' and end the subroutine...

Here is a sample of the code I am using:

Please Login or Register  to view this content.

EXAMPLE ISSUE:

My pivot filter has the following in the list:

A, B, C, D

My drop down has A,B,C,D

The following month, my pivot only has A,B,C
If someone selects D in my drop down, it OVERWRITES the most recent item selected in the pivot filter, renaming it 'D'

Thank you. I will go try this code!

EDIT: THIS WORKED PERFECTLY! Thank you so much!

EDIT: Need a little more help, see next post!

Had marked this as 'solved', but I want to know how to modify the above code to update 2 additional pivot tables with the same drop down selection value, one on the active sheet and one on another sheet called 'sheet 1' (for example)

Thank you. This will be helpful for most of my code!