I have a very nice Macro that several EE Pros helped build that calculates a Interval and Frequency (Date/Time) between a start date that is entered and an end date that is calculated by the existing macro.
I now need a macro addition that auto/dynamically (i.e. as the selections change) builds out the data table X will be the Interval values and Y1 and Y2 will have data that is manually put into the model. I believe the best way to then get it into a dynamic graphic is with Range Names that expand and contract based on the selections.
In the WB provided, I've outlined the 3 Steps that take place. The first two steps are calculated with the macro that is in place. The actual creation of a dynamic Table or Array is what I'm after in this new macro. Careful to take note that as you press the blue button, the format changes for what will be the X axis or Interval(s).
Thank you VERY much in advance. I know this is a tougher then normal request.