+ Reply to Thread
Results 1 to 3 of 3

Makes and Models

  1. #1
    Registered User
    Join Date
    07-12-2015
    Location
    Doncaster
    MS-Off Ver
    2010
    Posts
    3

    Post Makes and Models

    I have a Database that I need to create with makes and models of cars. I have a drop down menu for the makes of cars. is there anyway i could get another drop down menu for the models of that make of car.

    For example:
    I select Audi from the drop down menu
    The models will then update to all of the models for Audi

    Any help is appreciated

    Thanks C

  2. #2
    Forum Expert shg's Avatar
    Join Date
    06-20-2007
    Location
    The Great State of Texas
    MS-Off Ver
    2003, 2010
    Posts
    40,678

    Re: Makes and Models

    Welcome to the board.

    If you use autofilter with Make in one column, and Model in another, you'll get exactly that behavior in the dropdowns.

    See http://www.contextures.com/xlautofilter01.html
    Entia non sunt multiplicanda sine necessitate

  3. #3
    Registered User
    Join Date
    07-12-2015
    Location
    Doncaster
    MS-Off Ver
    2010
    Posts
    3

    Re: Makes and Models

    Thanks i'll try that

+ 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. [SOLVED] Counting & summing with 3 models
    By Jhon Mustofa in forum Excel Formulas & Functions
    Replies: 11
    Last Post: 03-06-2014, 12:42 PM
  2. [SOLVED] Finding Max # in a list of similar models
    By elcarp in forum Excel - New Users/Basics
    Replies: 4
    Last Post: 12-13-2012, 03:41 PM
  3. Excel 2007 : Customer retention models
    By gibmini in forum Excel General
    Replies: 5
    Last Post: 03-28-2012, 06:57 PM
  4. User models directory
    By icgeg in forum Excel General
    Replies: 0
    Last Post: 12-07-2010, 02:03 PM
  5. Code to different object models
    By Wboson in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 09-12-2005, 06:05 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