+ Reply to Thread
Results 1 to 2 of 2

Require Excel to display a variable outcome based on List Box Data

  1. 03-11-2015, 09:36 AM #1
    Sharperoc
    Sharperoc is offline
    Registered User
    Join Date
    03-11-2015
    Location
    Devon, England
    MS-Off Ver
    MS Office 2007
    Posts
    1

    Require Excel to display a variable outcome based on List Box Data

    Hi,

    Apologies for the somewhat vague title. I'm an absolute novice when it comes to Excel and I have been tasked with designing a spreadsheet to perform a particular task. I've searched around the net and watched a few instructional videos but I've been unable to find a particular process that handles everything I need the spreadsheet to do.

    I don't have an example spreadsheet to provide as I am working through the preliminary stages but I've attached an annotated picture which hopefully describes the sort of thing I would want my spreadsheet to do.

    Proposed Excel Mock-Up.JPG

    If you could provide any advice, or links to the sort of Formulas/Macros I might need to use that would be wonderful. I'm more than willing to do the leg-work myself as I will probably be asked to create more Spreadsheets like this in the future (if successful)

    Thanking you in advance.

    Sharperoc
    Reply With QuoteRegister To Reply
  2. 03-11-2015, 04:07 PM #2
    Pauleyb
    Pauleyb is offline
    Forum Expert
    Join Date
    06-26-2010
    Location
    Austin, TX
    MS-Off Ver
    Excel 2010
    Posts
    1,673

    Re: Require Excel to display a variable outcome based on List Box Data

    Since you are new to Excel, I would avoid the radio buttons and list boxes. You could do it (look up grouping radio buttons in excel, determine which radio button was seleceted in excel), but I see your layout and I think something like this may be a good solution: http://www.excel-easy.com/examples/d...own-lists.html
    This starts with an initial drop down list and then changes a second drop down based upon what the person selected in the first one. This can be chained to third or more drop downs and it shows you how to determine which selection was made and then to react (which is similar to using the radio button selection to change a displayed list).
    Pauley
    --------
    If I helped with your issue, I'd appreciate a rep bump (hit the '*' icon to the bottom left of this post).
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] Require a formula to look at the last entered data in a row and display it
    By john dalton in forum Excel Formulas & Functions
    Replies: 7
    Last Post: 05-21-2014, 10:45 AM
  2. Require help display trend in data
    By Andrew_MD7 in forum Excel - New Users/Basics
    Replies: 0
    Last Post: 02-19-2014, 11:17 AM
  3. Create list based on outcome of three columns
    By Arnifix in forum Excel General
    Replies: 3
    Last Post: 06-25-2010, 02:36 AM
  4. Create list based on outcome of three columns
    By Arnifix in forum Excel General
    Replies: 1
    Last Post: 06-24-2010, 02:38 AM
  5. does sorting based on a large filter list require a macro?
    By nimbenja in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 09-05-2007, 06:36 PM

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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1