# Rolling UP Table and Values

#### Kamusksn

##### New Member
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
Code:
``=TODAY()``
on the B1
Code:
``=DATE(YEAR(A1), MONTH(A1)+1, DAY(A1))``
C1, and so on.
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

### Excel Facts

How to calculate loan payments in Excel?
Use the PMT function: =PMT(5%/12,60,-25000) is for a \$25,000 loan, 5% annual interest, 60 month loan.
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
Code:
``=TODAY()``
on the B1
Code:
``=DATE(YEAR(A1), MONTH(A1)+1, DAY(A1))``
C1, and so on.
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

Hello and welcme,

What's your output should look like.

 Product FEB MAR APR MAY JUN JUL AUG SEP OCT NOV DEC FEB A 2 3 4 5 6 7 8 9 10 11 12 0 B 2 3 4 5 6 7 8 9 10 11 12 0

<tbody>
</tbody>

The ideal is move automatically on month change.

Replies
5
Views
246
Replies
6
Views
378
Replies
2
Views
157
Replies
6
Views
340
Replies
15
Views
292

1,196,329
Messages
6,014,680
Members
441,835
Latest member
rthomas268

### We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.

### Which adblocker are you using?

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

### Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

### Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back