Each month we have many Statements of Account need send to Customers for payment, and how to use a Macro to auto insert a Sub-total base on
Due Date column, also add remark " Sub-total" in the rows, sample file per attach, appreicate your help.
Any hints?
Hi David,
Normally, a macro is needed after evaluating if the result cannot be achieved with excel's default tools. This is not the case, your data structure is not a new one never seen before, can be done with a simple pivot table.
The pivot table can be configured as you need, with subtotal, grand totals and so on.
To replicate in vba what a pivot table does, it's a hard work for nothing, takes a lot of time to do what a pivot does in seconds, and the result is not as reliable as a pivot solution.
See attached file, you can play around and modify the design as needed.
Thanks got it !
