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

[NBVC]

Crossposted: http://www.excelforum.com/excel-form...nd-values.html
Crossposted: http://www.mrexcel.com/forum/excel-q...le-values.html

Please Read: http://www.excelguru.ca/content.php?184