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

How many items do you have on your Item tab? On average, how many items will
be selected and need to be added to the Quote form?

If the answer to either of those questions is 1000's then I'll pass!

If there might be up to a few hundred items and the Quote form might be
dozens then you can send me a copy of your file.

I'm at:

xl can help at comcast period net

Remove "can" and change the obviou.

Biff

"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

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