Total production of energy in a specific months

Originally Posted by MarvinP

Hi,

This looks like a job for Pivot tables. See the attached where I did a simple pivot table and then grouped the rows by month.

Thanks MarvinP
That helps but are there any way of automatically updating the content of a pivot table? I'm automatically collecting data from other sheets so the data will shift 1 day every day.
Thanks again