You're welcome ! Thanks for calling back ..

Here's a working sample to complement the suggested construct:
http://savefile.com/files/9241953
AutoCopy lines into new sht based on key col value
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"oasisoflife" wrote:
... Thanks a Lot Chaps I think I can work something out now
with the information you have given .