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