Joel Guest- thanks. That's very good and full appreciation for your
efforts.

Problem with it is: it doesn't provide the next value when there is an
occasion where a name occurs without a value but later does so.
For instance, a name mayoccur on row 1, re-occur on row 20 without a
value and again on row 40 with a value.
I need row 1 to retrieve the value on row 40.

I'll enclose attachment with your code and its product as it will
better illustrate.
Big thanks.
Colwyn.


+-------------------------------------------------------------------+
|Filename: example 2.xls |
|Download: http://www.thecodecage.com/forumz/attachment.php?attachmentid=61|
+-------------------------------------------------------------------+

--
colwyn
------------------------------------------------------------------------
colwyn's Profile: http://www.thecodecage.com/forumz/member.php?userid=34
View this thread: http://www.thecodecage.com/forumz/sh...ad.php?t=47019