Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Help to create calculation with code
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 *** Sent via Developersdex http://www.developersdex.com *** |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I create the following calculation based on volume | Excel Discussion (Misc queries) | |||
How to create a form to insert a hyerlink.VBA code to create a for | Excel Discussion (Misc queries) | |||
create time calculation formula | Excel Discussion (Misc queries) | |||
How to create a variable from a calculation | Excel Programming | |||
Create a newworksheet with VBA code and put VBA code in the new worksheet module | Excel Programming |