| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Loop that finds blanks, then subtotals values into different column
Hi there,
0 rows are my header rows, and 1 rows are individual order items. I need a loop that will find the blank cells in column E and then subtotal the values into column C of its header row. A B C D E 0 B100010 1 B100010 101303 1 82.92 1 B100010 101305 1 117.31 1 B100010 101307 1 90.02 0 B310003 1 B310003 215013 1 12.33 1 B310003 301503 1 10.75 0 B20055 1 B20055 303009 1 17.77 1 B20055 303011 1 25.67 1 B20055 303013 1 27.15 1 B20055 217001 1 31.55 I know it is basic stuff, but I need some help (I'm an excel VBA virgin!!) I am ok with the looping bit but can't think it through. I am running out of time and the will to live !! .... Anyone??? Thanks in advance |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Count values in array of data where no blanks in one column | Excel Worksheet Functions | |||
| Subtotals of Items in A Column based on Spec. Values found in Colu | Excel Discussion (Misc queries) | |||
| Counting multiple values (including blanks) in one column | Excel Discussion (Misc queries) | |||
| Create a macro that finds values then sorts | Excel Worksheet Functions | |||
| Trying to select values in a column with blanks | Excel Programming | |||
Threaded Mode
