Forum Discussion
Locking numbers in calendar
Hi, I have 3 tabels where i need the total sum of them to be put in a calender. I would like it to be automatic but I don't know how. I already have the total sum of the tabels. But now I ne...
If I'm interpreting this correctly you have multiple daily tables that get filled in and you want the final totals each day to get transfered (automatically) to the calendar table and then reset the daily tables to be re-filled in the next day?
If that is correct, then you would have to use macro(VBA) or scripts to automatically (or semi-automatically) do this. Alternatively you can just alter your input table to have day, time, person,... and log all of the information in the input table(s) and then just report the summary data in the calendar. Another alternative is to use power automate in sharepoint or forms in excel to create an input form that is repeatedly filled in and then logged into an excel sheet .
the only other option I can think of would be to use circular references (and set options to iterative calculations to 1) to have each date = sum of the values (or particular cell) if TODAY()=date or =itself if not, but that is not something I would recommended.
If that is correct, then you would have to use macro(VBA) or scripts to automatically (or semi-automatically) do this. Alternatively you can just alter your input table to have day, time, person,... and log all of the information in the input table(s) and then just report the summary data in the calendar. Another alternative is to use power automate in sharepoint or forms in excel to create an input form that is repeatedly filled in and then logged into an excel sheet .
the only other option I can think of would be to use circular references (and set options to iterative calculations to 1) to have each date = sum of the values (or particular cell) if TODAY()=date or =itself if not, but that is not something I would recommended.