HelpMeWithExcelPlease
New Member
- Joined
- Jul 27, 2017
- Messages
- 24
I am creating a Gantt chart and one of the last steps is getting a view of milestones on my Gantt. For this I would like to insert a shape whenever column C has a value, "Yes" and then place the shape on the row based on the date entered in column E.
Here is what my sheet looks like so far, with the Gantt view on the right hand side of the table, using conditional formatting to fill in for the length of the tasks:
[TABLE="class: grid, width: 500"]
<tbody>[TR]
[TD]ID[/TD]
[TD]Description[/TD]
[TD]Milestone?[/TD]
[TD]Start[/TD]
[TD]End[/TD]
[TD]3/1[/TD]
[TD]3/2[/TD]
[TD]3/3[/TD]
[TD]3/4[/TD]
[TD]3/5[/TD]
[TD]3/6[/TD]
[TD]3/7[/TD]
[TD]3/8[/TD]
[/TR]
[TR]
[TD]1[/TD]
[TD]Regression Testing[/TD]
[TD][/TD]
[TD]3/1/2018[/TD]
[TD]3/3/2018[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]2[/TD]
[TD]Project Go Live[/TD]
[TD]Yes[/TD]
[TD]3/2/2018[/TD]
[TD]3/2/2018[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]3[/TD]
[TD]Sprint 3[/TD]
[TD][/TD]
[TD]3/5/2018[/TD]
[TD]3/8/2018[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]4[/TD]
[TD]Conversion[/TD]
[TD]Yes[/TD]
[TD]3/7/2018[/TD]
[TD]3/7/2018[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]
My question is on how I would go about writing vba code to have a shape inserted into the right cell if column C had a value "Yes" and then the shape would be placed on that row based on the End date in column E. Any ideas?
Your suggestions and direction are greatly appreciated, thank you!
Here is what my sheet looks like so far, with the Gantt view on the right hand side of the table, using conditional formatting to fill in for the length of the tasks:
[TABLE="class: grid, width: 500"]
<tbody>[TR]
[TD]ID[/TD]
[TD]Description[/TD]
[TD]Milestone?[/TD]
[TD]Start[/TD]
[TD]End[/TD]
[TD]3/1[/TD]
[TD]3/2[/TD]
[TD]3/3[/TD]
[TD]3/4[/TD]
[TD]3/5[/TD]
[TD]3/6[/TD]
[TD]3/7[/TD]
[TD]3/8[/TD]
[/TR]
[TR]
[TD]1[/TD]
[TD]Regression Testing[/TD]
[TD][/TD]
[TD]3/1/2018[/TD]
[TD]3/3/2018[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]2[/TD]
[TD]Project Go Live[/TD]
[TD]Yes[/TD]
[TD]3/2/2018[/TD]
[TD]3/2/2018[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]3[/TD]
[TD]Sprint 3[/TD]
[TD][/TD]
[TD]3/5/2018[/TD]
[TD]3/8/2018[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]4[/TD]
[TD]Conversion[/TD]
[TD]Yes[/TD]
[TD]3/7/2018[/TD]
[TD]3/7/2018[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]
My question is on how I would go about writing vba code to have a shape inserted into the right cell if column C had a value "Yes" and then the shape would be placed on that row based on the End date in column E. Any ideas?
Your suggestions and direction are greatly appreciated, thank you!