Rolling UP Table and Values

Kamusksn

New Member
Joined
Mar 26, 2013
Messages
3
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.

ProductJANFEBMARAPRMAYJUNJULAUGSEPOCTNOVDEC
A123456789101112
B123456789101112
 

Some videos you may like

Excel Facts

Can you AutoAverage in Excel?
There is a drop-down next to the AutoSum symbol. Open the drop-down to choose AVERAGE, COUNT, MAX, or MIN

Robert Mika

MrExcel MVP
Joined
Jun 29, 2009
Messages
7,256
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.
 

Kamusksn

New Member
Joined
Mar 26, 2013
Messages
3
Product
FEBMARAPRMAYJUNJULAUGSEPOCTNOVDECFEB
A
234567891011120
B
234567891011120

<tbody>
</tbody>

The ideal is move automatically on month change.
 

Watch MrExcel Video

Forum statistics

Threads
1,108,732
Messages
5,524,513
Members
409,583
Latest member
RedHelp

This Week's Hot Topics

Top