If everything in your item # list has different numbers then you would want
to setup a table and in your quote form you would enter the item number and
then the qty. It would then pull from the table the description and costs.


"Brian W" <Brian wrote in message
...
I have a workbook with two tabs, one tab is my spreadsheet with item #'s,
prices, etc and the second spreadsheet is a quote form. What I want to do
is
when I put in a quantity on my price list form and it calcualtes total
price,
I want it to transfer that information to my quote form and build a
complete
quote based on the items I selct in the price sheet. I only want the items
that I put quantities in the price sheet to show up in the quote. Can
someone
PLEASE help me. I can send my spreadsheets to anyone that is willing to
help.

Thanks
Brian