Question about setting a function in a weekly calendar that can modify information for a month/year.

[Lavigne_Michael]

---

Hello,

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.

Thank you

Michael