Typo, sorry ..

Line
.. until the last value in col B, with blank rows ("") thereafter

should read as:
.. until the last value in col A, with blank rows ("") thereafter
--
Rgds
Max
xl 97
---
Singapore, GMT+8
xdemechanik
http://savefile.com/projects/236895
--