I created a combo box , e.g "state" selections. (see attached Sheet 1)
In Sheet 2, I have two pivot tables that I want the exact same "state" to be selected as the combo box in Sheet 1.
How shall I write the VB code? Can someone help me with a similar example?