My question would be a little long. I have from cell A2 to A50 numbers. In cell B2 to B50 I have formula that calculates SUM of some cells. In Cell C1 to N1 I have January to February. Now in C2 I have formula that says if A2=1 (1 for January) then type B2(SUM formula result in B2), in C3 if A3=1 then B3. Same thing for column D. In D2 if A2=2 (2 for February) then type B2. After I finished putting numbers in column A, under January to December the numbers all over the place according to number in column A. Now what I need to know If I can type lets say in A100 to L100 "January to December" and underneath each month pick number from previous table in line them up.
(example what I have in table)
A B
1 Jan Febr Mar Apr May
1 2 2.5 2.5
2 3 3.5 3.5
3 2 6.5 6.5
4 1 8.5 8.5
5 2 4.5 4.5
6 3 2.4 2.4
(example what I want after)
Jan Febr Mar Apr May
100 8.5 2.5 3.5
101 6.5 2.4
102 4.5
103
104
(example what I have in table)
A B
1 Jan Febr Mar Apr May
1 2 2.5 2.5
2 3 3.5 3.5
3 2 6.5 6.5
4 1 8.5 8.5
5 2 4.5 4.5
6 3 2.4 2.4
(example what I want after)
Jan Febr Mar Apr May
100 8.5 2.5 3.5
101 6.5 2.4
102 4.5
103
104