Forum Discussion
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 weekly basis and should therefore also be automatically transferred/adjusted to the month.
Please help me! ❤️
I have put an example in the attachment, you are welcome to edit it.
Does this do what you want?
8 Replies
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?
