Results 1 to 3 of 3

Thread: Serious Financial Model

  1. #1

    Exclamation Serious Financial Model



    Register for a FREE account, and/
    or Log in to avoid these ads!

    Hello,

    I am comparing a series of different products across different years with varying amounts of dollars spent depending on the type of "contract". I want to make these into a series of drop down menus. Meaning that once you click on one drop own menu, the next menu will give you another choice.

    For example:

    • Product Type
    • Forecasted % Change for specific year
    • Type of Contract


    Is this possible? I know this is a pain, but I'm hoping anyone might be willing to help me. Thank you!

  2. #2
    Acolyte candybg's Avatar
    Join Date
    Jul 2015
    Posts
    92
    Articles
    0
    Excel Version
    2010 and 2016
    I needed something similar just last month! What you are looking for is called Dependent Drop-down Lists and since I'm new, I can't share the link to the site I learned this from. But if you search Google for :
    excel dependent drop down lists
    the site was at the top of the search results.

    The site shows how this is used and then how to set this up in Excel using lists.

  3. #3
    Administrator Ken Puls's Avatar
    Join Date
    Mar 2011
    Location
    Nanaimo, BC, Canada
    Posts
    2,401
    Articles
    45
    Blog Entries
    14
    Excel Version
    Excel Office 365 Insider
    Here's the link to Debra's excellent article on creating Dependent Drop Down Lists

    Hope that helps,
    Ken Puls, FCPA, FCMA, MS MVP

    Learn to Master Your Data at the Power Query Academy (the world's most comprehensive online Power Query training), with my book M is for Data Monkey, or our new Power Query Recipe cards!

    Main Site: http://www.excelguru.ca -||- Blog: http://www.excelguru.ca/blog -||- Forums: http://www.excelguru.ca/forums
    Check out the Excelguru Facebook Fan Page -||- Follow Me on Twitter

    If you've been given VBA code (a macro) for your solution, but don't know where to put it, CLICK HERE.

Tags for this Thread

Posting Permissions

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