Price List and Quote Form

[Brian W]

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

 

[T. Valko]

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

 

[Ed Davis]

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.

 

[Kevin G]

Hi

I read your post about a price sheet you posted a while back. Did you manage to get it working?

I would really appreciate it if you could send me an example of how you managed to do it.

Kind regards.

Kevin




Brian wrote:

Price List and Quote Form
07-Apr-07

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

Thank
Brian

Previous Posts In This Thread:

Price List and Quote Form
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

Thank
Brian

How many items do you have on your Item tab?
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 ne

Remove "can" and change the obviou

Bif


If everything in your item # list has different numbers then you would want to
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



Submitted via EggHeadCafe - Software Developer Portal of Choice
A Comparison of Managed Compression Algorithms
http://www.eggheadcafe.com/tutorial...arison-of-managed-compression-algorithms.aspx