I am having a lot of trouble creating this and would love some help. Basically what I need is to type in a worksheet is projects with a Title, Start Date and Finish Date. I then need this to be presented in another worksheet with number 1-31 in B1, C1 etc and Jan - Dec in A2, A3 etc. In the grid I would like areas shaded, for example 2nd feb to 28th march, with the Title to show in the shading: Based on what was entered in the previous worksheet.
And also have a restriction that projects cannot overlap, if a project is extended say from 28th march to 2nd april it will push the start and finish dates of future projects forward.
Also, have it so users can only enter project Title, Start Date and Finish Date; Have the choice of two colours for the shading on the calendar; And cannot edit anything else.
Is this possible to do in excel and how would I go about it?
Any help would be great! Thanks!