Forum Discussion

kabu2024's avatar
kabu2024
Copper Contributor
Aug 21, 2024

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 need something to put them into a calendar for save keeping.

 

Is there any way to put them in the calender automatically?

 

Please ask any question if I'm onclear on anything.

Thanks in advance.

 

 

 

 

 

 

 

Excel
Formulas and Functions
Macros and VBA
  • m_tarler's avatar
    m_tarler
    Steel Contributor
    Aug 21, 2024
    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.

Resources