Rolling UP Table and Values

[Kamusksn]

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

=TODAY()

on the B1

=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

 

[Robert Mika]

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

=TODAY()

on the B1

=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.

 

[Kamusksn]

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.