- Nov 29, 2016
I couldn't find this question in my searches, but I have added a week calendar worksheet to my year calendar workbook. Each month has a different worksheet and I wanted to set a formula where I can change hours worked on a certain day in the week worksheet and that will go through each month worksheet and modify the days to have the same number of hours. I am using this to speculate future hours and sales numbers to meet certain goals. This may be a simple formula that I am not aware of, but I haven't been able to figure it out yet.