Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Please help macro guru's
I have numerous sets of volumes that are recorded from a pump. I am trying to write a macro to totalize the volumes for each set in column B to to get a total volume in column C. I can manually do this in excel buit want a macro as I have hundreds to totalize. See how the total volume in column C at the Set1 row becomes the cell above the Set1 statment in column C plus the volume in column B at the Set1 statment row. Each value for the set 1 total volume is the next volume in column B plus that last volume in Column C (that was the end of Set 0). My problem is I can't figure out how to lock the value in column C above each new set statement and have all cells in B added to it outputting in column C. Of tricky note is that the numbers in column B and the set statements that go with them are not uniform in number and size and that a set can have more or less volume(e.g more or less columns) A B C Volume Total Volume 2423.616211 2423.616211 2423.758301 2423.758301 2423.900635 2423.900635 2424.042725 2424.042725 Set1 1.504936337 2425.547661 1.955039501 2425.997764 2.405142546 2426.447867 5.072114468 2429.114839 7.739086151 2431.781811 10.40605831 2434.448783 13.07302952 2437.115754 Set2 4.737580776 2441.853335 9.475161552 2446.590916 14.21274281 2451.328497 18.9503231 2456.066077 23.68790436 2460.803658 28.42548561 2465.54124 Thank you Ben |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Autofilling a formula down | Excel Programming | |||
Autofilling | Excel Programming | |||
Autofilling INPUTBOX | Excel Programming | |||
Help with autofilling formulas | New Users to Excel | |||
autofilling cells | Excel Worksheet Functions |