Hello,

I am trying to set up a spreadsheet where only four weeks of data are shown at a time and the dates are automatically updated to show only the current week along with the following four weeks. The format of the spreadsheet is shown below. I know that I have to write some code in VBA but I'm not sure whether my spreadsheet is formatted optimally and whether this is possible at all. Thanks so much, any help is appreciated

spreadsheet.png