You're welcome, Sandy !
Thanks for posting back
--
Rgds
Max
xl 97
---
GMT+8, 1° 22' N 103° 45' E
xdemechanik <atyahoo<dotcom
----
"Sandy" wrote in message
...
Thanks Max
That helps some. However the lists are maintained separately in separate
workbooks. For now I have linked the first part of the long list to the
short list and am using the lists separately for each sheet. Not sure if
the most efficient way but I think it will work

Thanks again!