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?
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?
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?