Anthony G.
Active Member
- Joined
- Mar 24, 2002
- Messages
- 465
Hello to All!
The Budget's on Sheet1: 1,960 & 1,965 are contingent upon which Rep and Discipline are selected from drop-down menus, therefore, being that there will always be one number associated with Reading or Language Arts, I can easily extropolate those by using the formula included in this example. However, I'm looking to get creative with the sales numbers.
As you will notice in Sheet2, I've listed 3 sub-categories for both Reading and Lang Arts. I was hoping that I could somehow include a scroll bar to carry out the following: the fisrt product Ihighest value) in the list would always appear in the cell (BFD), then each time a user clicks the scroll bar, it would input that product into the cell and thus provide a new number as well...so if a user clicked twice (being that BFD is already in the cell) he would then see BFA, then BFC.
Now, if this is possible, would I need another scroll bar for Language Arts as well?
Any advice, as always, is greatly appreciated.
Take Care.
Anthony
The Budget's on Sheet1: 1,960 & 1,965 are contingent upon which Rep and Discipline are selected from drop-down menus, therefore, being that there will always be one number associated with Reading or Language Arts, I can easily extropolate those by using the formula included in this example. However, I'm looking to get creative with the sales numbers.
As you will notice in Sheet2, I've listed 3 sub-categories for both Reading and Lang Arts. I was hoping that I could somehow include a scroll bar to carry out the following: the fisrt product Ihighest value) in the list would always appear in the cell (BFD), then each time a user clicks the scroll bar, it would input that product into the cell and thus provide a new number as well...so if a user clicked twice (being that BFD is already in the cell) he would then see BFA, then BFC.
Now, if this is possible, would I need another scroll bar for Language Arts as well?
Any advice, as always, is greatly appreciated.
Take Care.
Anthony
Forecast Template.xls | ||||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
D | E | F | G | H | I | J | K | L | M | N | O | P | Q | R | S | |||
10 | Sheet1 | Sheet2 | ||||||||||||||||
11 | Budget | Sales | State | Rep | Subject | Product | Sales | |||||||||||
12 | StateTotal: | NewYork | NewYork | SteveMMumm | Reading | BFD | 300 | |||||||||||
13 | NewYork | SteveMMumm | Reading | BFA | 200 | |||||||||||||
14 | RepTotal: | StevenMMumm | NewYork | SteveMMumm | Reading | BFC | 100 | |||||||||||
15 | NewYork | SteveMMumm | LanguageArts | BDJ | 700 | |||||||||||||
16 | NewYork | SteveMMumm | LanguageArts | BDG | 600 | |||||||||||||
17 | Discipline: | Reading | 1,960 | NewYork | SteveMMumm | LanguageArts | BEC | 500 | ||||||||||
18 | BFD | 300 | ||||||||||||||||
19 | ||||||||||||||||||
20 | LanguageArts | 1,965 | ||||||||||||||||
21 | BDG | 700 | ||||||||||||||||
Language_Arts |