moving data from a form to another sheet
 

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

moving data from a form to another sheet
 

"Kimberly Heffernan" wrote
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
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---