Here's an alternative to consider ..
An easy formulas set-up
which automates the exact functional deliveries you seek
(from my past response to another similar poster)

Illustrated in this sample:
http://www.savefile.com/files/1945932
Parent to Child AutoCopy Model based on KeyCol Values.xls
(full construct details, nicely rendered, easy to understand n adapt)

Take it away, get it up and working ...
Then come back here for a high-five, click YES below
--
Max
Singapore
http://savefile.com/projects/236895
Downloads:23,500 Files:370 Subscribers:66
xdemechanik
---
"Chad Portman" wrote:
I can not send the workbook to anyone for company reasons and the idea of
filter and copy paste does not work well cause something I forgot to mention
is the original list gets updated every 30 mins.