Hello again Excel world,

I have a basic expense report in Excel with categories along the top row and dollar amounts and totals below. I want to write a macro (or if there's a more intuitive way I'm open to that too) that allows me to generate a monthly summary report showing totals for each category and a couple charts. I can easily make a dashboard that updates the data each month, but I don't want the accountant to have to create it manually every month. Any tips on how to do this? I'd appreciate VBA code or a template or anything.

Thank you!

Alison