Slight errata to this line:
Put in B2:
=IF(ROWS($1:1)COUNT($A:$A),"",INDEX(Sheet2!A:A,SM ALL(A:A,ROWS($1:1))))

It should be

Put in B2:
=IF(ROWS($1:1)COUNT($A:$A),"",INDEX(Sheet2!A:A,SM ALL($A:$A,ROWS($1:1))))


... SMALL($A:$A,.. -- col A should be fixed for copying B2 across/down
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---