Hello everybody

I have an Excel (2000) project the part of whitch is to print out an order
with a list of items for that particular order number. I have a sheet with
columns OrderNumber, Item, Description, Qty and Prize.
In the Order sheet I enter the order number and want a macro to copy the
corresponding items rows to the order sheet.

I manually enter only the order number in a validation list box and want
this to trigger reading the items. I did it with Autofilter, but how to
scroll the autofilter list down. Copy an paste is not possible - but I want
to cell by cell copy the item information rows.

Sounds very simple - but I got stuck with it...

--
Håkan