creating a table with variable numbers of rows

[smsampson]

That may not be a properly descriptive title to this request.

What I need to do is to check against a summary table and fill in rows between the ones in the summary. The value in each row of the summary table needs to be used when we get to that in the new table. The attached sample file shows it.
Column B highlighted in yellow is what I want to stretch out. Column C contains the values that I will be working with.
So between 1 (value 95) and 2.5 (value 103) there is a difference of 9 (103-95). Therefore there need to be 9 rows that get filled in with (2.5-1)/9+previous row put in col F. This makes every row the same distance apart.

But when I get to the difference between 5 (value 109) and 2.5 (value 103) the difference is now 6 (109-103). So now there need to be 6 rows that get filled in with (5-2.5)/6+previous row.

So what I need is some type of if statement that can check when the number of rows needed is complete so that it can move down a row and pull the values for F and G directly from the summary table before starting to calculate the in between values for the extra rows.

I'm not so worried about adding rows on the fly. I can copy it down so that it is longer than needed and chop off the end. I just need the if formulas to dynamically change as it pulls from the table because ultimately I want to apply this to different tables which will have different values in col D.

thanks for any help
Maureen