I want to do a daily Gantt chart. I have a single sheet that has among its variables:
Task Name | Start Day | End Day | Start Hour | End Hour
On another sheet, I have tables set up for day 1, day 2, etc. Each table is set up with the columns:
Task Name | 0:00 | 1:00 | 2:00 | ... | 23:00 (That's 24 hours.)
My main problem is how to dynamically add rows to my table so that its conditional formatting can take place to display a Gantt Chart style of set up.
So... How do I add a row to a table using a formula?
Once again, I'm trying not to re-learn VBA, unless I absolutely have to do so.
Any suggestions? I'm still web searching, but I'm not sure how to do this one without VBA.
Task Name | Start Day | End Day | Start Hour | End Hour
On another sheet, I have tables set up for day 1, day 2, etc. Each table is set up with the columns:
Task Name | 0:00 | 1:00 | 2:00 | ... | 23:00 (That's 24 hours.)
My main problem is how to dynamically add rows to my table so that its conditional formatting can take place to display a Gantt Chart style of set up.
So... How do I add a row to a table using a formula?
Once again, I'm trying not to re-learn VBA, unless I absolutely have to do so.
Any suggestions? I'm still web searching, but I'm not sure how to do this one without VBA.