+ Reply to Thread
Results 1 to 5 of 5

Database of products and auto generated quotation based on quantities choosed

Hybrid View

  1. #1
    Registered User
    Join Date
    07-14-2015
    Location
    lisbon
    MS-Off Ver
    2016
    Posts
    68

    Database of products and auto generated quotation based on quantities choosed

    Hi everyone,

    1 - I have a big Database of products and i would like to have a file with all those products where Clients can place the quantities they want to buy, and on a different sheet according to those quantites a quotation be generated, ignoring all the products they didnt choosed.

    Is this possible with formulas?


    2 - Second question not so important, but in the same file would it be possible, when choosing the quantities (without data validation) with formulas some products have rules of multiples or multiples and minimum order quantities?

    I attach and example of what i would want for easier understanding.
    Thanks and any questions i will try to clarify them.
    Attached Files Attached Files

  2. #2
    Forum Moderator - RIP Richard Buttrey's Avatar
    Join Date
    01-14-2008
    Location
    Stockton Heath, Cheshire, UK
    MS-Off Ver
    Office 365, Excel for Windows 2010 & Excel for Mac
    Posts
    29,464

    Re: Database of products and auto generated quotation based on quantities choosed

    Hi,

    If you're prepared to have the Total G7 cell above the data then what you ask is possible.
    Otherwise since presumably the numbers of products may vary, unless you limit the choices to 5, then the 6th and subsequent products won't fit in.

    Normally of course this would be driven by a macro which could adjust as necessary, but since you rule it out you'll either need to make the quotation large enough for the maximum number of choices possible, in which case presumably many quotes will have a lot of blank rows, or put the total above the product rows.
    Last edited by Richard Buttrey; 06-14-2016 at 11:24 AM.
    Richard Buttrey

    RIP - d. 06/10/2022

    If any of the responses have helped then please consider rating them by clicking the small star icon below the post.

  3. #3
    Registered User
    Join Date
    07-14-2015
    Location
    lisbon
    MS-Off Ver
    2016
    Posts
    68

    Re: Database of products and auto generated quotation based on quantities choosed

    Hi and thanks for the help,

    I didnt even thought of that!!! But i understand what you are saying now...

    Yes, the total (in the example G7 cell) can be above, no problem with that.

  4. #4
    Forum Moderator - RIP Richard Buttrey's Avatar
    Join Date
    01-14-2008
    Location
    Stockton Heath, Cheshire, UK
    MS-Off Ver
    Office 365, Excel for Windows 2010 & Excel for Mac
    Posts
    29,464

    Re: Database of products and auto generated quotation based on quantities choosed

    Hi,

    See attached

  5. #5
    Registered User
    Join Date
    07-14-2015
    Location
    lisbon
    MS-Off Ver
    2016
    Posts
    68

    Re: Database of products and auto generated quotation based on quantities choosed

    Hi,

    Thanks, that is what i needed. Itīs perfect!!!


    I just dont understand in the first sheet "Products Database" the formulas in collumn I and the numbers in collumn A, was that just some tests you made or they mean anything?

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Replies: 7
    Last Post: 06-11-2015, 04:11 AM
  2. Counting Quantities of Products Sold
    By FSOMarc in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 11-14-2013, 06:46 PM
  3. Replies: 3
    Last Post: 06-04-2013, 02:56 AM
  4. Replies: 1
    Last Post: 05-02-2012, 05:44 AM
  5. Replies: 3
    Last Post: 12-24-2011, 09:19 AM
  6. Change Pivot table fields to generate chart based on button choosed
    By booo in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 09-29-2010, 03:03 PM
  7. Help needed on making a Quotation database
    By Henry Ignatius in forum Excel General
    Replies: 1
    Last Post: 09-01-2010, 03:54 AM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1