Hi All,
I have a report that I pull from Sage into Excel, however it creates Subtotals for each of the Suppliers invoices.
As you can imagine there's quite a few suppliers on the list and the totals from the report don't contain an autosum amount, just the text amount from the report.
Is there an easy way in which I can make a macro that will create the autosum for each of the subtotals so if I manipulate the data and delete rows, it generates the correct subtotal?
Thanks,
RevZ
I have a report that I pull from Sage into Excel, however it creates Subtotals for each of the Suppliers invoices.
As you can imagine there's quite a few suppliers on the list and the totals from the report don't contain an autosum amount, just the text amount from the report.
Is there an easy way in which I can make a macro that will create the autosum for each of the subtotals so if I manipulate the data and delete rows, it generates the correct subtotal?
Thanks,
RevZ