In advance, let me say - Thank you for all of your help.



I’m sorry if this has been answered before. I’m not sure what I should search on to see if this has been discussed.

I’m trying to figure out if this can be done in Excel, and if so, how do I do this. I have 10 BA’s that work for me, and, at any one time, each BA may have several projects. Each project will have several milestone dates that can last a day or up to a week.

What I am trying to do is manage each BA and their projects and see which BA could take on a new project based upon the new projects milestone dates.

Is there a way to see all BAs and their projects by date in one spreadsheet in a calendar or Timeline chart format? And I need to be able to update the spreadsheet with each new project and have it automatically update the calendar or chart.

Thank you for all of your help.

Joe