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