I’m sure there must be an easy way to do this but I can’t work out how! Please help!
I have a project plan as Tab 1 in a spreadsheet – it has tasks under different themes e.g. general/stakeholder engagement/comms down column 1 and then across the top the days with week 1/week 2 etc so that for each task, the relevant cell under the day it is to be completed is coloured in. That all works fine but ends up quite large. What would be good is to separate out each theme into its own worksheet so that if someone only works on stakeholder engagement, they can see all the relevant information for that theme.
Another element of this is that the worksheet runs the entirety of the project life e.g. May 2016- May 2017. But senior management would like to see a breakdown of just the next 8 weeks. So i would like to set something up where Tab 2, Tab 3, Tab 4…etc auto populate with the information on their theme from Tab 1 and only for the next 8 weeks.
Is there any way to do this?