I need to be able to click on the drop down and pick a month which is in F1 and the whole sheet changes with it to reflect any changes that are made to each calendar
A | B | C | D | E | F | G | H | |
---|---|---|---|---|---|---|---|---|
1 | November,2017 | Sun | Mon | Tue | Wed | Thu | Fri | Sat |
2 | 1 | 2 | 3 | 4 | ||||
3 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | |
4 | 12 | 13 | 14 | 15 | 16 | 17 | 18 | |
5 | 19 | 20 | 21 | 22 | 23 | 24 | 25 | |
6 | 26 | 27 | 28 | 29 | 30 | |||
7 |
Array Formulas
<tbody> </tbody> Note: Do not try and enter the {} manually yourself |
That little bit of information tells me hardly nothing.