- Can I create multiple plans in the one workbook and relate these together?
Yes! Simply select the bottom worksheet tab. Right click and select copy. This will create a second and fully operational version of your template in your workbook. You can then create links, between the two sheets as you normally would with an excel workbook. This feature is particularly useful if you are managing multiple projects. Consider also building your own multiple project status report as a new workbook that looks at each sheet an summarises the information for you.Note: The view (Daily, Weekly and Monthly) and the planning window start date can only be set once in the workbook. This is set by changing these variables in the original "Project Planning" worksheet. The newly created plans will be fully functional for planning purposes. You may consider just using the original "Project Planning" worksheet as a control sheet for the rest of your plans.