If you mean auto-"copy" lines from a parent sheet (that would be your
"form")
to individual "child" sheets (sheets by product name) going by the product
names listed in a key col in the parent sheet, try this recent posting: http://tinyurl.com/28mz9s
There's a sample file given which illustrates the functionality,
link reproduced below: http://www.freefilehosting.net/download/3d0e4
AutoSlice lines by ID col to respective sheets.xls