Hi Everyone, I want help to start this little job
I need roll up one table and it's values, The Ideal will be automatically change if we are on a new month... and that its no problem with the months
In the A1 Cell I put
on the B1
C1, and so on.
But i need ideas for roll up also the information below the months.
I need roll up one table and it's values, The Ideal will be automatically change if we are on a new month... and that its no problem with the months
In the A1 Cell I put
Code:
=TODAY()
Code:
=DATE(YEAR(A1), MONTH(A1)+1, DAY(A1))
But i need ideas for roll up also the information below the months.
Product | JAN | FEB | MAR | APR | MAY | JUN | JUL | AUG | SEP | OCT | NOV | DEC |
A | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 |
B | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 |