Macro: Automatic Reset with New Slicer Selection

[RLBrown]

Excel Guru's,

I have a beautiful opportunity calculator that I've recently built. I contains a list of markets, for which I have a Slicer (from data pivot table). What I can't figure out is how to write a macro that automatically resets data in 11 specific cells when a new market is selected.

Note: I have limited experience writing macros and/or VBA. So when providing assistance, plese keep this in mind.

THANK YOU!!