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...