dear all, how to sum up the total for each of the category below in
vba? when next row is empty then can do a sum up. for example a shell
and head will be 4650 when encounter an empty row after linda.
can help. thanks


a shell and head
andy 50
sussy 100
linda 4500

b nozzle
james 98
zortan 340

c manhole
bryan 34
fendi 444