Hello,

I have a worksheet that contains distance intervals (From, To) however
there are gaps between the intervals, (below)

ID From (ft) To (ft)
1 1 4
2 6 8
3 8 12
4 17 20
5 20 25
6 25 30
7 36 40


I would like to fill in the gaps to display a continuous set of
intervals (below).

ID From (ft) To (ft)
1 1 4
**1.5 4 6*
2 6 8
3 8 12
*3.5 12 17
4 17 20
5 20 25
6 25 30
**6.5 30 36*
7 36 40

I think I need a macro to perform this task but any insight would be
helpful.
The macro needs to be able to recognize a gap between a “To” value and
the following “From” value. It then needs to insert a row between the
interval gap and fill in the fields with the appropriate values.

Thank you, thank you, thank you.

Tim K


--
tking
------------------------------------------------------------------------
tking's Profile: http://www.excelforum.com/member.php...o&userid=24811
View this thread: http://www.excelforum.com/showthread...hreadid=383679