Insert Row and sum certain cell value using Loop on condition
<p>I'm really new to VBA Excel and supervisor had me to do some macro, the ultimate purpose is inserting row and sum certain value of cells, </p>

<p><a href="https://i.stack.imgur.com/xl76S.png" rel="nofollow noreferrer">please click this for the image</a>
I don't know what is the function but I know the logic,
Read the value of A8:B8 then read to below cell A9:B9 and so on if empty continue until the value is different then insert rows</p>

<p>also when Inserting rows below column "20DRY", "40DRY", "40HDRY" is SUM of cell value BAS, ERS, LSS.</p>

<p>Any help very appreciated.</p>

<p>Edit:</p>

<p>My question, how we add value to temporary array, and go to next cell below eg A8 go to A9, looping continuously if we found different value from current array and next array then we create a new entire row, SUM certain column?</p>

<p>Sorry if I didn't mention this before.</p>