Hi all,
I'm using the calendar templates available in excel 2013 and wondering if what I'm trying to do is possible. I've already added a drop down list of the 27 people this applies to.
I have a data sheet, with resource name, task start date, task end date &what the task in individual comments. This data comes from an MS project I've built.
Not everyone on the project has access to MS project (limited copies etc.) and I've been asked provide a easy to use, visual representation for peoples individual tasks. which is where the excel calendar comes in.
I'd like to make it so people can click on themselves (or others in the drop down list - I'm happy for it to display only on person at a time) and look at each month for the life of the project.
this is where i draw a blank (was thinking a vlookup or sumproduct to get the data in at first)..
eventually i'd like to have it represent similar to outlook ie a colored bar (or similar) with the task labelled, going across the entire period allocated for the task. In some instances there maybe more more then one task for one individual at any time.
Is this something i can actually make in excel or is it too complex?
thanks in advance
I'm using the calendar templates available in excel 2013 and wondering if what I'm trying to do is possible. I've already added a drop down list of the 27 people this applies to.
I have a data sheet, with resource name, task start date, task end date &what the task in individual comments. This data comes from an MS project I've built.
Not everyone on the project has access to MS project (limited copies etc.) and I've been asked provide a easy to use, visual representation for peoples individual tasks. which is where the excel calendar comes in.
I'd like to make it so people can click on themselves (or others in the drop down list - I'm happy for it to display only on person at a time) and look at each month for the life of the project.
this is where i draw a blank (was thinking a vlookup or sumproduct to get the data in at first)..
eventually i'd like to have it represent similar to outlook ie a colored bar (or similar) with the task labelled, going across the entire period allocated for the task. In some instances there maybe more more then one task for one individual at any time.
Is this something i can actually make in excel or is it too complex?
thanks in advance
