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.
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.
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.