i have just inserted a row bewteen two points i want to auto sum average the amount into the newly created row . I want to do this for each new row i

[jwalkerack]

Hey Guys , so this is the Second part of my Problem

Kevatarvind , was really kind to show my how to insert multiple rows .

http://www.mrexcel.com/forum/excel-...-1-row-between-every-row-has-entry-excel.html

But now i would like to populate these newly created rows with an auto sum average of the above and below data

Is there a macro that will Auto sum average for every cell that is blank between 2 points ?

for example is is possible to auto sum average bewteen the points in the below table without entering all the data in manually

time	Distance
6	1
9	2
15	3
25	4
67	5
89	6
100	7
140	8
189	9
220	10

<colgroup><col><col></colgroup><tbody>
</tbody>

<colgroup><col><col></colgroup><tbody>
</tbody>