Hi

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).

Any suggestions?

Thanks!!!

Best Regards

Jessica Layson