There is a table that contains member IDs and credits allocated, which I would like to periodically summarize and distribute to a member of staff. I wish to sum the member IDs duplicated across multiple days, with different credit values, resulting in:
A. Smith 23
B. Jones 12
C. Young 75
It is possible to create this output with a pivot table, but I need to be able to distribute it automatically, without a staff member’s knowledge. While I can send regular email/Slack outputs, I cannot get the summary to work (perhaps with scripting).