Hi all,<?xml:namespace prefix = o ns = "urn:schemas-microsoft-comfficeffice" /><o></o>
<o></o>
I have looked for this answer but no luck. My apologies if it is lurking somewhere in a past post.<o></o>
<o></o>
I have a functional Gantt chart that I would like to use as the input for a calendar tab. I could use nested if statements inside each calendar cell, but there are two problems. As I add a job to the Gantt chart (each job is listed in it's own row) I would have to go back to the calendar cells of each day and add another nested IF statement. And second, even if each calendar cell had all the IF statements in the world, it would only be good for that month and I would have to recreate the whole thing for the next month.<o></o>
<o></o>
I have thought about using a matrix that sits off to the side of the calendar (out of view) that lists the number of each day and the column of the corresponding Gantt data (on a separate tab) and then using Match and/of Index to lookup if the Gantt cell has a job in it that needs to be carried over to the calendar. Then use a dynamic IF statement that could be copied and pasted to each month with only the matrix needing to be updated.<o></o>
<o></o>
Sorry to be so verbose but I often see the first question is please provide more detail, so here it is if you want it:<o></o>
<o></o>
Gantt chart is on one tab. Monthly calendar is on another tab (due to formatting). I would like to have the monthly calendar dynamically update as the Gantt chart updates.<o></o>
<o></o>
Thanks in advance for your help!<o></o>
<o></o>
MM<o></o>
<o> </o>
<o></o>
I have looked for this answer but no luck. My apologies if it is lurking somewhere in a past post.<o></o>
<o></o>
I have a functional Gantt chart that I would like to use as the input for a calendar tab. I could use nested if statements inside each calendar cell, but there are two problems. As I add a job to the Gantt chart (each job is listed in it's own row) I would have to go back to the calendar cells of each day and add another nested IF statement. And second, even if each calendar cell had all the IF statements in the world, it would only be good for that month and I would have to recreate the whole thing for the next month.<o></o>
<o></o>
I have thought about using a matrix that sits off to the side of the calendar (out of view) that lists the number of each day and the column of the corresponding Gantt data (on a separate tab) and then using Match and/of Index to lookup if the Gantt cell has a job in it that needs to be carried over to the calendar. Then use a dynamic IF statement that could be copied and pasted to each month with only the matrix needing to be updated.<o></o>
<o></o>
Sorry to be so verbose but I often see the first question is please provide more detail, so here it is if you want it:<o></o>
<o></o>
Gantt chart is on one tab. Monthly calendar is on another tab (due to formatting). I would like to have the monthly calendar dynamically update as the Gantt chart updates.<o></o>
<o></o>
Thanks in advance for your help!<o></o>
<o></o>
MM<o></o>
<o> </o>