I will try to keep this short but I want to make sure that I include all of
the details.

I am making an order form on excel. I want to be able to fill in the details
on one page and have that page sent over onto a new page that will in turn
get sent to my supplier.

The list of stuff I can order from is roughly 8 pages long and the list I
send him is usually only 2 pages long.

Is there a way to copy only the information that has an amount associated
with it (as in I want to order 2 of these vs. 0 of another item)
automatically. Up until now I have just been deleting manually the items that
we have not ordered but I know there has got to be an easier way for myself
(and others who don't know excel) to do this.

If I need to clarify please let me know. Also, I am using Excel 2003.

Thanks