I need some help here

[Ragnarok]

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 here: http://www.geocities.com/ragnarok_v2/Help.xls

I really hope someone here can help me ou

 

[Don Guillett]

try data>filter>autofilter>filter on non blanks>copy to another sheet.
Record while doing.

 

[Guest]

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 here: http://www.geocities.com/ragnarok_v2/Help.xl

I really hope someone here can help me ou

 

[Debra Dalgleish]

You could use data validation and VLookup formulas to create an order
form. There's an example on my web site:

http://www.contextures.com/excelfiles.html

Under 'Data Validation', look for 'Order Form'

 

[Ragnarok]

Thnx guys for your help!

I'm gonna try out all of your ideas and hopefully one of them is what
i'm looking for.

I'll let you guys.

 

[Ragnarok]

*You could use data validation and VLookup formulas to create a
order
form. There's an example on my web site:

http://www.contextures.com/excelfiles.html

Under 'Data Validation', look for 'Order Form'

*

The Order Form is exactly what i'm looking for

But how did you make that, i couldn't find any scripts

When I know where i can find the scripts i can alter them to my ow
needs