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

Hi Drew

Why not filter a column with amount and copy the visible cells to a new workbook and send that

Do you want to mail the workbook ?
Let me know and I make a macro for you

Tell me which column is the amount column and in which row it start

--

Regards Ron de Bruin
http://www.rondebruin.nl/tips.htm


"Drew" wrote in message ...
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