asked on
EE Professionals,
I am trying to construct, in Excel 2010, a Gantt Chart time line (Tab 2) based on some very specific Input (Tab1). I believe that a Macro vs. formulas approach is better because the order in the Input Tab may change dynamically and the record count (i.e. could be 10 Tasks, could be 100), is unknown and also changes.
SPECIFICATIONS:
In Tab 1, a Macro needs to look at Column A and determine there is a Task or numeric number (vs. a Blank) and if a whole number, then task = a Major Task; if fractional (e.g. 1.1, 1.2, or 1.11, 1.21, etc.), then it's an associated Sub Task.
ALSO,
In Tab 1, a Macro needs to also look at Column E and determine if there is the letter "R"; if so, then and only then should it post the Start and Due Dates to the Gantt Chart. This means that there may be a number of Tasks in the Gantt Chart that are incomplete...and that's OK. Only Tasks and Subtasks that meet the critieria of having an "R" in Column E on the Input Tab should have an associated time line set lf values and appear on the Chart. Only Major Tasks should appear without a Time Line on the Gantt Chart; all other Minor Subtasks will only appear if they meet the criteria of having an "R" in Column E.
Example File attached.
In advance, "thank you" for the assistance on this.
B.
RASCI-Gantt-Chart-v1.xlsm
I am trying to construct, in Excel 2010, a Gantt Chart time line (Tab 2) based on some very specific Input (Tab1). I believe that a Macro vs. formulas approach is better because the order in the Input Tab may change dynamically and the record count (i.e. could be 10 Tasks, could be 100), is unknown and also changes.
SPECIFICATIONS:
In Tab 1, a Macro needs to look at Column A and determine there is a Task or numeric number (vs. a Blank) and if a whole number, then task = a Major Task; if fractional (e.g. 1.1, 1.2, or 1.11, 1.21, etc.), then it's an associated Sub Task.
ALSO,
In Tab 1, a Macro needs to also look at Column E and determine if there is the letter "R"; if so, then and only then should it post the Start and Due Dates to the Gantt Chart. This means that there may be a number of Tasks in the Gantt Chart that are incomplete...and that's OK. Only Tasks and Subtasks that meet the critieria of having an "R" in Column E on the Input Tab should have an associated time line set lf values and appear on the Chart. Only Major Tasks should appear without a Time Line on the Gantt Chart; all other Minor Subtasks will only appear if they meet the criteria of having an "R" in Column E.
Example File attached.
In advance, "thank you" for the assistance on this.
B.
RASCI-Gantt-Chart-v1.xlsm
Learn from the best
Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.
Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 1 Answer and 12 Comments.
Try for 7 days”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.
Our community of experts have been thoroughly vetted for their expertise and industry experience.