LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 6
Default Totalizing a value and Autofilling contents

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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Autofilling a formula down CLR Excel Programming 5 June 7th 08 02:46 PM
Autofilling Faboboren Excel Programming 7 November 26th 07 05:48 PM
Autofilling INPUTBOX Rick[_32_] Excel Programming 2 April 23rd 07 06:42 PM
Help with autofilling formulas moncara New Users to Excel 1 June 21st 06 11:42 PM
autofilling cells Tim Excel Worksheet Functions 1 February 4th 05 11:10 PM


All times are GMT +1. The time now is 06:41 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"