Hi guys,
I am attempting to create an Excel sheet for managing a project.
I would like to plan the project on one tab (lets call the tab 'Project Planning'), with 5 categories/colums: #, Task, Start Date, End Date and Duration (duration is calculate by End Date-Start Date' + 1 (I don't want the difference, I want the number of total days)).
On the next tab I would like the page to be setup in a calendar view, which each separated month and individual days. The data entered on the first tab will automatically fill in the appropiate cells of the date set. I don't know if this is too much to ask, or even possible, but it would be great if new lines appeared automatically for when more tasks were added on the first tab.
I have no idea if this is even possible.
I am an Ok Excel user who can follow simple instructions. I would preefer to avoid VBA and all that jazz, Conditional Formatting is hopefully the answer.
I've manually drawn what I am talking (about and what I want) and screenshotted an example and attached it (the thread asked me to use a URL, I have no idea if the image works).
I have added a screenshot od a manual drawing I did (what I want the finished piece to look like).
Thanks in advance,
Danny
Bookmarks