Log In
Register
Home
December 5, 2016
Offline
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.
See AnswerDecember 5, 2016
Offline
Any hints?
Power Query
Power Pivot
Xtreme Pivot Tables
Excel for Decision Making
Excel for Finance
Excel Analysis Toolpak
Power BI
Excel
Word
Outlook
Excel Expert
Excel Customer Service
PowerPoint
November 8, 2013
Offline
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.
Answers Post
1 Guest(s)
