It is not wise to post your email in the newsgroups
Here's one of my past offerings on this topic -- a relatively simple,
non-array formulas model to deliver the exact functionalities requested --
one which is easily understood and adapted to suit:
http://cjoint.com/?bdxZClvygO
AutoCopy_Lines_by_Emp_IDs_to_Resp_Shts.xls
Take it away. Success? hit the YES below, drop me a line here ..
--
Max
Singapore
---