Forum Discussion
Solved
Summing daily data to monthly data (Automatically)
Hello 🙂 I have daily data in Sheet 1 and would like to have it automatically totalled per month in the second sheet. It is important to emphasise that the daily data is automatically updated on a w...
Does this do what you want?
LarissaM711 How a bout a simple pivot table? See attached.
- Thank you for your help!
But If I understand correctly, the pivot table does not adjust automatically when new daily data is added, does it?Well, that takes on button click, but the totaling happens automatically. And there are manners to make it more dynamic. How crucial really is this automatic (instant) updating? What Excel version are you using, by the way?
You say you get weekly data. I wonder from where, what format. Is it an Excel file, perhaps a csv/txt file?
- It's very crucial that this will update automatically, because it's just one of many customer-Reportings and would take some time. If there was no solution at all, that would be OK but not the optimal solution.
It's used in Google Sheets and the Data comes from the Tool Supermetrics as a Connector for Instagram.
