Hello all, i have a spreadsheet that has columns 2008 to 2012. under
each heading is a total and then 2 lines below that i have a value for
each month, Jan to Feb, as indicated below. I use a calculation in
another cell
=SUM(O74:O82,Q69:U69)Which would be from the value 4,500 in 2008 to the
bottom (Dec) and then the totals for 2009 to 2012. I would like to
create this with code. The starting point would be taken from another
sheet giving me the start year and month, which would tell me which
column(year) and which line(Month) and then the totals for the other
years. Any help would be very much appreciated.

2008 2009 2010 2011 2012
51,930 55,920 51,700 51,480 1000
16% 18% 16% 16% 0%
4,106 4,026 3,722 3,707 72
4,671 5,033 4,653 4,633 90
4,443 5,312 4,912 4,891 95
4,500 4,306 3,981 3,964 77
4,540 5,536 5,118 5,097 99
4,710 5,312 4,912 4,891 95
5,325 5,592 5,170 5,148 100
2,115 3,411 3,154 3,140 61
2,480 3,467 3,205 3,192 62
6,500 5,816 5,377 5,354 104
5,400 5,592 5,170 5,148 100
3,140 2,516 2,327 2,317 45

Best regards,

Les Stout


Best regards,

Les Stout

*** Sent via Developersdex http://www.developersdex.com ***

Can you use a Pivot table to do this?
http://peltiertech.com/Excel/Pivots/pivottables.htm
Post back if that doesn't work for you...

Regards,
Ryan--

--
RyGuy


"Les Stout" wrote:

Hello all, i have a spreadsheet that has columns 2008 to 2012. under
each heading is a total and then 2 lines below that i have a value for
each month, Jan to Feb, as indicated below. I use a calculation in
another cell
=SUM(O74:O82,Q69:U69)Which would be from the value 4,500 in 2008 to the
bottom (Dec) and then the totals for 2009 to 2012. I would like to
create this with code. The starting point would be taken from another
sheet giving me the start year and month, which would tell me which
column(year) and which line(Month) and then the totals for the other
years. Any help would be very much appreciated.

2008 2009 2010 2011 2012
51,930 55,920 51,700 51,480 1000
16% 18% 16% 16% 0%
4,106 4,026 3,722 3,707 72
4,671 5,033 4,653 4,633 90
4,443 5,312 4,912 4,891 95
4,500 4,306 3,981 3,964 77
4,540 5,536 5,118 5,097 99
4,710 5,312 4,912 4,891 95
5,325 5,592 5,170 5,148 100
2,115 3,411 3,154 3,140 61
2,480 3,467 3,205 3,192 62
6,500 5,816 5,377 5,354 104
5,400 5,592 5,170 5,148 100
3,140 2,516 2,327 2,317 45

Best regards,

Les Stout


Best regards,

Les Stout

*** Sent via Developersdex http://www.developersdex.com ***

Hi ryguy7272, unfortunately not. It must be created by code if possible

Best regards,

Les Stout

*** Sent via Developersdex http://www.developersdex.com ***

How do you determine that the 4500 is the starting point? Do you have a column of dates somewhere?

HTH,
Bernie
MS Excel MVP


"Les Stout" wrote in message ...
Hello all, i have a spreadsheet that has columns 2008 to 2012. under
each heading is a total and then 2 lines below that i have a value for
each month, Jan to Feb, as indicated below. I use a calculation in
another cell
=SUM(O74:O82,Q69:U69)Which would be from the value 4,500 in 2008 to the
bottom (Dec) and then the totals for 2009 to 2012. I would like to
create this with code. The starting point would be taken from another
sheet giving me the start year and month, which would tell me which
column(year) and which line(Month) and then the totals for the other
years. Any help would be very much appreciated.

2008 2009 2010 2011 2012
51,930 55,920 51,700 51,480 1000
16% 18% 16% 16% 0%
4,106 4,026 3,722 3,707 72
4,671 5,033 4,653 4,633 90
4,443 5,312 4,912 4,891 95
4,500 4,306 3,981 3,964 77
4,540 5,536 5,118 5,097 99
4,710 5,312 4,912 4,891 95
5,325 5,592 5,170 5,148 100
2,115 3,411 3,154 3,140 61
2,480 3,467 3,205 3,192 62
6,500 5,816 5,377 5,354 104
5,400 5,592 5,170 5,148 100
3,140 2,516 2,327 2,317 45

Best regards,

Les Stout


Best regards,

Les Stout

*** Sent via Developersdex http://www.developersdex.com ***

Hi Bernie, i get the starting point from a sheet that tells me the start
month and year.

Best regards,

Les Stout

*** Sent via Developersdex http://www.developersdex.com ***