VBA code or a solution to create rolling schedule

Where would the values in column F of the dashboard come from?

How would the values/progress for your milestones be entered?

All the input is coming from the Support file. I have used filter function to filter the status from the support file. Milestones, dates and status are from the Support file. As for the colors, I have used If And function and used conditional formatting. All these are altered and filtered as per the event. The only place I am unable to change as per the event is the no of weeks rolling.  When the no of weeks is updated in the Support file I want to able to either create the rolling weeks for the no of weeks listed in Support file or delete the extra weeks and retain only the weeks listed in Support file

I just created a dummy file to post it here. The cell references might bot be the same but I can change that according to the original template

And you won’t see the Support file updated with all the data that is reflected in the Dashboard. The dates are created in the Dashboard template. The first date is from the support file( used the = cell in support file) and then the rolling dates are calculated manually in the dashboard template. Using first date + 7. Sorry I missed to give that in the dash board. 

The only data I see in the support file is "No of weeks".

Also please tell me, step by step including user actions, how you see this working.

I have attached the file which has 2 sheets. Dashboard and Support. Support has all the input data. Dashboard has the formulas to pull the data from the Support sheet. The Milestone table is pulled through filter formula. J12 get the start date from the support file. From there the rolling dates are calc manually in the dashboard template using J12+7 and so on.

From J13 to AM14, has the formulas and conditional formatting to reflect the colors based on the dates and the status.

The dashboard has 30 rolling weeks listed as part of the template. Based on the no of weeks listed in Support sheet, I want to able to delete the extra weeks from the template. For example if no of weeks is 8, the macro should keep the first 8 weeks and be able to delete the dates and the formulas from column R13 to AM16. If the no of weeks is 12 then the date and formulas from V13 to AM16 should be deleted

I downloaded both your workbooks a second time and again the only data I see in the support file is "No of weeks".

Please try this. Both the files are combined in the same file. Support has the Milestones table, the start date and the no of weeks.

Dashboard-Template.xlsx

Okay now I see the data and that's progress, but starting with a blank dashboard I need you to tell me, step by step including user actions, how you see this working.

So I plan on using this a template so team members can change the data in the Support sheet for their events. They can update the start date, the milestones table and the no of weeks. So once thr data is updated in support sheet, it starts reflecting in the dashboard. Now, the problem I have is, that the rolling weeks are calculated manually in the Dashboard sheet. And formulas below the dates to highlight them based on the status is also updated there manually for 30 weeks. Some events run just for 8 or 12 weeks. In that scenario I don’t wabt to see the extra weeks in the Dashboard sheet. So I want to able to run a code which can delete the dates and the formulas below that, based on the no of weeks updated in the support sheet. If no of weeks says 8 I should only see 8 weeks in Dashboard. If no of weeks is 12 I shud see only 12 weeks and rest of the weeks and formulas below that deleted

Else it would be great if there is way to create or add the rolling dates and the formulas under the dates based on the no of weeks updated in the support sheet. Like a macro that can add the formulas and the dates

I'm sorry but I don't think I can help you with this.

So is there is a way you can route this someone who can help?

I requested help for you.

Thank you!!

This is a good idea. It works well. So based on the no of weeks the dates are appearing in row 12 now. But in the original template I have basically put in the formula from row 13 and below to show the rag status for 24 weeks by default. I plan to use this as a template and can be made copies for every event. I also have the dates in row 12 formatted in a different color for 24 weeks. So based on the no of weeks updated in Support sheet, is there a way I could remove the format if the date is not in there and also remove the formulas from row 13 and below. For example if the no of weeks is 8, then from column R on the row 12 no dates appear. But the formatting still is there. And on rows 13 and down the formula still exists. So I basically want to be able to format these cells and remove the formulas if row 12 is blank for a date

I got it covered.. thank you so much for the abovr solution

You're welcome! I'm glad it worked out for you!!