What are you using for an interface, a Form or direct worksheet interaction
This is the line of code to copy one row to another shee

Selection.Entirerow.Copy destination:= WorkSheets("Order").
Rows( WorkSheets("Order").Usedrange.Rows.count +1


----- Ragnarok wrote: ----

I need help with a bit of EXCEL.

I have to create an order form in excel in which people can orde
products that the supermarket will deliver at home.

As you may have thought supermarkets have tons of products so printin
all products per costumer will cost a lot of paper. So my idea is tha
when costumers have chosen an amount of a certain product then tha
product will be added on the sheet that i named 'order'

know this is where my problem comes in....how can i let excel place th
row of a product which a costumer has ordered from the 'productlist
sheet to the 'order' sheet.

To give you a better idea of what i mean i have place the link to m
.xls he http://www.geocities.com/ragnarok_v2/Help.xl

I really hope someone here can help me ou


--
Message posted from http://www.ExcelForum.com