I'm trying to automate a time sheet generator. problem I have is that total time for the day has to be divided across number of jobs for the day and the type of activity. I.E. if I have 4 (VARIABLE NUMBER) jobs for the day, the time is equally divided between each, but each one will have 3 separate activity entries. Job 1 codes LC, ND and LC etc..
Is there a way to automatically populate cells to reflect this? so that it outputs like this: