Good morning,
I'm looking for an Excel formula to put into Tab #1 (cell A6)that will change automatically when the number month in Tab #1 (cell A4) changes. I already have a formula that drives the change in Tab #1 (cell A4) based upon data in Tab #2. Any assistance would be greatly appriciated.
Thank you
Brian
<COLGROUP><COL style="WIDTH: 48pt" width=64><COL style="WIDTH: 59pt; mso-width-source: userset; mso-width-alt: 2889" width=79><COL style="WIDTH: 48pt" span=7 width=64><TBODY>
</TBODY>
I'm looking for an Excel formula to put into Tab #1 (cell A6)that will change automatically when the number month in Tab #1 (cell A4) changes. I already have a formula that drives the change in Tab #1 (cell A4) based upon data in Tab #2. Any assistance would be greatly appriciated.
Thank you
Brian
Tab #1 | ||||||||
Cell | A | |||||||
4 | 11 | |||||||
5 | ||||||||
6 | November | |||||||
Tab #2 | ||||||||
Cell | A | B | C | D | E | F | G | H |
2 | Month | Month # | Enter the Current Report Month # | 11 | ||||
3 | January | 1 | ||||||
4 | February | 2 | ||||||
5 | March | 3 | ||||||
6 | April | 4 | ||||||
7 | May | 5 | ||||||
8 | June | 6 | ||||||
9 | July | 7 | ||||||
10 | August | 8 | ||||||
11 | September | 9 | ||||||
12 | October | 10 | ||||||
13 | November | 11 | ||||||
14 | December | 12 |
<COLGROUP><COL style="WIDTH: 48pt" width=64><COL style="WIDTH: 59pt; mso-width-source: userset; mso-width-alt: 2889" width=79><COL style="WIDTH: 48pt" span=7 width=64><TBODY>
</TBODY>