How to schedule refresh for next/prev week in a calendar work schedule

[sbatabyal]

Hi,

I am working on a schedule with shapes and I am stuck on a problem. When I click on Next week on the calender it gives me an error. What I am trying to do is when clicked on next week it should show me a fresh calender without any data in "Site Works" section (E5:K8), and also when I click on Prev week, it should show me the already entered data. Attached code and worksheet for reference. Thanks for looking into it.

Please Login or Register  to view this content.