I started with this solution here: Number of columns equal to cell value
I want to create multiple tables down the page which will be at a fixed number of rows of 11. This inital set up that I have is in the attached image, enter image description here.
I have a row in the table labelled Week which is unmerged and I want a value from Start Date to populate the first free column. I then want to take the Length in Weeks value and expand or contract the number of columns in the table to match that number and then prefill the dates in the Week row and finally fill the End Date cell.
The weeks go from Monday to Sunday, once an End Date is filled then the Start Date in the next row will fill and then wait for the user to input the Length in weeks to go through the process with a similar table down the page.
My problem at the moment is whether Excel VBA has the functionality I would need to pull this off or whether I should shift to Python and then just export an excel sheet.
I started with this solution here: Number of columns equal to cell value
I got it to add the columns onto the existing one but I had issues with merged rows and it also wasn't dynamic to make the table smaller if I entered a smaller number.