Hello Everyone,
I'm sort've new to Excel and writing code in VBA. I have the following situation: my company tries to make revenue predictions at its many sites (740 sites). We are the midst of creating a forecast method and we'd like to compare the old one to the new one. So currently I have a Spin Button that runs through each site individually and gives me the best predictor. I'd like to count how many times the predictor is named. I.e when I scroll, Pred1 is show, then Pred1 after scrolling again, then Pred2 and so on...So I'd like to know a way or create a macro that could count the total of Pred1, regardless of site scrolled on. Thanks in advance.
Jean
I'm sort've new to Excel and writing code in VBA. I have the following situation: my company tries to make revenue predictions at its many sites (740 sites). We are the midst of creating a forecast method and we'd like to compare the old one to the new one. So currently I have a Spin Button that runs through each site individually and gives me the best predictor. I'd like to count how many times the predictor is named. I.e when I scroll, Pred1 is show, then Pred1 after scrolling again, then Pred2 and so on...So I'd like to know a way or create a macro that could count the total of Pred1, regardless of site scrolled on. Thanks in advance.
Jean