Hey All! Newbie to VBA, first time poster!
Looking for help on how to write a VBA script that will delete subtotal groups equal to zero. We are implementing a new system and starting a new process for a goods received but not invoiced account and this will be a a way of reconciling the account. I have already written code to format the data, sort by PO number, then subtotal by PO number. The next step should delete the PO subtotals equal to zero, that way we can track and review all outstanding items in the account.
A little about the file:
- Purchase order numbers in column H
- Amounts (subtotal function and system generated values) column I
- The amount of rows that can make a subtotal group has to be flexible, as there can be multiple receipts and invoices per purchase order
- Each month we will roll over the prior month's file that way we can track changes
- Would also be nice to have in the subtotal row a formula that pulls the min value of the date of the transactions in the subtotal group (oldest transactions per each PO). This would help easily identify the oldest transactions that way they can be reviewed periodically.
Looking forward to your replies and help!!
Looking for help on how to write a VBA script that will delete subtotal groups equal to zero. We are implementing a new system and starting a new process for a goods received but not invoiced account and this will be a a way of reconciling the account. I have already written code to format the data, sort by PO number, then subtotal by PO number. The next step should delete the PO subtotals equal to zero, that way we can track and review all outstanding items in the account.
A little about the file:
- Purchase order numbers in column H
- Amounts (subtotal function and system generated values) column I
- The amount of rows that can make a subtotal group has to be flexible, as there can be multiple receipts and invoices per purchase order
- Each month we will roll over the prior month's file that way we can track changes
- Would also be nice to have in the subtotal row a formula that pulls the min value of the date of the transactions in the subtotal group (oldest transactions per each PO). This would help easily identify the oldest transactions that way they can be reviewed periodically.
Looking forward to your replies and help!!
