Excel 2007
<tbody>
</tbody>
<tbody>
</tbody>Excel 2007
<tbody>
</tbody>
<tbody>
</tbody>Excel 2007
<tbody>
</tbody>
<tbody>
</tbody>Excel 2007
<tbody>
</tbody>
<tbody>
</tbody>Excel 2007
<tbody>
</tbody>
<tbody>
</tbody>Excel 2007
<tbody>
</tbody>
<tbody>
</tbody>Excel 2007
<tbody>
</tbody>
<tbody>
</tbody>Excel 2007
<tbody>
</tbody>
<tbody>
</tbody>
Row\Col | A | B | C | D | E | F | G | H | I | J | K | L |
---|---|---|---|---|---|---|---|---|---|---|---|---|
1 | Mar-15 | Apr-15 | May-15 | Jun-15 | Jul-15 | Aug-15 | Sep-15 | Oct-15 | Nov-15 | Dec-15 | Jan-16 | Feb-16 |
<tbody>
</tbody>
Sheet: Sheet1 |
<tbody>
</tbody>
Row\Col | A |
---|---|
3 | The current accounting month (Feb-16) is the last column, plus the previous 11 months, so my table always shows a year. |
<tbody>
</tbody>
Sheet: Sheet1 |
<tbody>
</tbody>
Row\Col | A |
---|---|
5 | What happens every month, I hide the 1st month of the 11 months so as to keep the total months equals to12; |
<tbody>
</tbody>
Sheet: Sheet1 |
<tbody>
</tbody>
Row\Col | A |
---|---|
6 | let’s see the next accounting month (Mar-16): |
<tbody>
</tbody>
Sheet: Sheet1 |
<tbody>
</tbody>
Row\Col | A | B | C | D | E | F | G | H | I | J | K | L |
---|---|---|---|---|---|---|---|---|---|---|---|---|
7 | Apr-15 | May-15 | Jun-15 | Jul-15 | Aug-15 | Sep-15 | Oct-15 | Nov-15 | Dec-15 | Jan-16 | Feb-16 | Mar-16 |
<tbody>
</tbody>
Sheet: Sheet1 |
<tbody>
</tbody>
Row\Col | A |
---|---|
8 | (I'll hide Mar-15 column in the actual sheet), and the new table will look like (Keep assuming Row number is still 1): |
<tbody>
</tbody>
Sheet: Sheet1 |
<tbody>
</tbody>
Row\Col | A | B | C | D | E | F | G | H | I | J | K | L | M | N |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
10 | Column | A | B | C | D | E | F | G | H | I | J | K | L | M |
11 | Row 1 | Mar-15 | Apr-15 | May-15 | Jun-15 | Jul-15 | Aug-15 | Sep-15 | Oct-15 | Nov-15 | Dec-15 | Jan-16 | Feb-16 | Mar-16 |
12 | Colmun A1 to be hidden |
<tbody>
</tbody>
Sheet: Sheet1 |
<tbody>
</tbody>
Row\Col | A |
---|---|
14 | I want a formula that will refer to the first month of the first 11 months. (in the 1st table, it's Mar-15 [Cell A1], the 2nd table it's Apr-15 [Cell B1). |
15 | When I reach accounting month Apr-16, columns A and B will be hidden; formula'll refer to cell C1 (May-15). |
16 | The formula- I guess- should be like the indirect function, either gives the refrence of the cell or shows the contents (doesn't matter). |
17 | I know it's simple, but I admit it, I'm no good in Excel, Please HELP. |
<tbody>
</tbody>
Sheet: Sheet1 |
<tbody>
</tbody>