+ Reply to Thread
Results 1 to 2 of 2

Creating active drop down lists, with prices and other variable

  1. #1
    Registered User
    Join Date
    07-10-2017
    Location
    North West
    MS-Off Ver
    2010
    Posts
    1

    Creating active drop down lists, with prices and other variable

    Hi all, i am relatively new to this but learning quickly.

    I need help with my excel spreadsheet i'm making to use for quotations. I would like to have a drop down for the 3 purchase options of our products (Purchase, Hire and Hire from new). Then on the Item Information/product list, when an item is selected the relevant price to appear in an adjacent column labelled RATE. Each product will have 3 different prices based on the 3 product options. If that makes sense.
    I have all the data/prices and products input into a separate sheet in the workbook. Please help.
    The format is simple, Row along the top for 3 purchase options(in drop down list), with 3 rows below. Product(in drop down list), quantity (to be entered manually) and Rate(auto input based on purchase option + selected Product from list)
    Along with a total amount at the bottom.
    Any help is much appreciated

    CSW

  2. #2
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Ipswich, England
    MS-Off Ver
    Office 365 (Win 10 - Work) & Office 365 Subscription Insider (Win 10 - Home)
    Posts
    39,641

    Re: Creating active drop down lists, with prices and other variable

    Welcome to the forum!

    This question has been asked many times, so there are lots of threads that are relevant; however, you could do worse than by starting here: http://www.contextures.com/xlDataVal02.html
    Ali


    Enthusiastic self-taught user of MS Excel who's always learning!

    Forum Rules (updated September 2018): please read them here.
    How to use the Power Query code you've been given: help here. More about the Power suite here.
    Don't forget to say "thank you" to those who have helped you in your thread. If you wish, you can also reward them by clicking on their reputation star bottom left.

+ 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. Sorting using two variable drop down lists.
    By brian01tj in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 04-23-2015, 07:12 PM
  2. Dependent drop down lists without creating unique named lists
    By pajordan in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 09-11-2013, 12:20 PM
  3. [SOLVED] drop down lists using a variable input
    By Allsort in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 08-12-2013, 10:02 AM
  4. Variable Drop Down Lists
    By williduck in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 11-15-2011, 02:09 PM
  5. drop down lists referencing tables creating other drop down lists!!
    By Stumped- in forum Excel - New Users/Basics
    Replies: 3
    Last Post: 08-07-2009, 11:29 AM
  6. [SOLVED] Creating Drop Down lists
    By Sam151 in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 06-28-2006, 04:55 PM
  7. creating drop down lists
    By Seymour in forum Excel Charting & Pivots
    Replies: 2
    Last Post: 03-09-2005, 08:06 PM

Tags for this Thread

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