moving data from a form to another sheet

[Kimberly Heffernan]

I have data on a form that I need moved to another sheet based on a product
name. How do I do this

 

[Max]

I have data on a form that I need moved to another sheet based on a product
name. How do I do this

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