Steve Belsch
12-19-2019, 01:56 PM
VBA Experts,
I could use some help with some code. I have attached an workbook with the code that I have built so far. What the code does is calculates subtotals on the each unique PO# (column A). Then it adds 5 blank rows.
Here is my issue:
I want the Subtotal formula to include all the rows for that specific PO and the blank rows. For example in the tab named "05.301", PO# 237932 the Code will insert a row in row 20. Then it will calculate the subtotal and then insert 5 blank rows. But the formula looks like this =Subtotal(9,M$3:M19) and I want it to include the additional blank rows so it should be =Subtotal(9,M$3:M24). And I don't want the the last cell (M24 in this example) in the equation locked, no $.
Any ideas?
Thanks.
Steve
I could use some help with some code. I have attached an workbook with the code that I have built so far. What the code does is calculates subtotals on the each unique PO# (column A). Then it adds 5 blank rows.
Here is my issue:
I want the Subtotal formula to include all the rows for that specific PO and the blank rows. For example in the tab named "05.301", PO# 237932 the Code will insert a row in row 20. Then it will calculate the subtotal and then insert 5 blank rows. But the formula looks like this =Subtotal(9,M$3:M19) and I want it to include the additional blank rows so it should be =Subtotal(9,M$3:M24). And I don't want the the last cell (M24 in this example) in the equation locked, no $.
Any ideas?
Thanks.
Steve