Try this tutorial:
http://www.officearticles.com/tutori...soft_excel.htm
************
Anne Troy
www.OfficeArticles.com

"wrinkle35" wrote in
message ...

Okay I need a little bit of help. I have a product order form with
sizes, colours, description ect. In that order form is a drop down cell
that says EMB or SS.
What needs to happen is that the size, colour, description copy over to
the EMB or SS worksheet when the user chooses EMB or SS from the drop
down.
The other issue I have is that the size and other information needs to
drop down a row when another item is added.
Can anyone help me?


--
wrinkle35
------------------------------------------------------------------------
wrinkle35's Profile:
http://www.excelforum.com/member.php...fo&userid=2374
View this thread: http://www.excelforum.com/showthread...hreadid=471156