VBA Code to extract subtotals

[Howardc]

I am looking for VBA code to extract the row number and sub-total in Col B in sheet 1, where the value is not zero for eg if the sub-total value is for eg 50, -50 etc., but to ignore zeroes

I would like row numbers containing the sub-total values that are not zero to be extracted to sheet2.

I have manually extracted the Row # in Col A and the value in Col B on Sheet2 to give an idea of what the extraction must look like

Your assistance in this regard is most appreciated


VBA Code to extract subtotals