I would like to copy the content from cells above blank cells to subtotal rows. (In this example, columns A, C and D). The last row should be determined by Column B, which contains the filter for the subtotals.
There is something wrong with my syntax, and I can't figure it out.
My code is...