Hello,

I need to be able to select an item from two data validation dropdowns in
Sheet1 and have the pivot table in Sheet2 show those selections in the
corresponding Page fields.

For example, on Sheet1, my first dropdown selection in cell A1 may be
"Texas"; my second dropdown selection in cell A2 may be Fritos. Once I make
these selections, I need my Pivot Table on Sheet2 to reflect these selections.

Thank you in advance for your help!