+ Reply to Thread
Results 1 to 5 of 5

View Table based on drop down list selection

  1. #1
    Registered User
    Join Date
    09-20-2018
    Location
    New Zealand
    MS-Off Ver
    2016
    Posts
    4

    View Table based on drop down list selection

    Hi,
    I'm having trouble finding a solution to this...any help would be greatly appreciated.
    I've created an indoor cricket scoring spreadsheet for our local competition.
    It has two sheets - one with team names across the columns, with names of the players under each team name.
    In the other sheet I have the game scoring info.
    There's a drop down list to select the first batting team, and a second drop down list to select the fielding team.

    What I'd like to do , which I'm having difficulty with is, to display the players names down the column.
    eg selecting the batting team, and the names of all the players appear down the column under batting team and the names of the players in the fielding team down another column
    under fielding/bowlers.
    The players names will change depending on which team is selected from the drop down list.

    There's probably a simply solution, but haven't been able to find it!

    many thanks

    cheers
    vin

    Have attached an earlier version of the spreadsheet.... the current version is saved on another laptop currently at home.
    The yellow area, is where the players names should appear based on the team selected at the top of the page, under fielding team.
    Attached Files Attached Files
    Last edited by wiseguy00; 09-20-2018 at 05:56 AM. Reason: attaching file

  2. #2
    Forum Guru Pete_UK's Avatar
    Join Date
    12-31-2011
    Location
    Warrington, England
    MS-Off Ver
    Office 2019 (still learning)
    Posts
    24,604

    Re: View Table based on drop down list selection

    It would help if you attached a sample Excel workbook.

    To do this, click on Go Advanced (below the Edit Window) while you are composing a reply, then scroll down to and click on Manage Attachments and the Upload window will open. Click on Browse and navigate to (and double-click) the file icon that you want to attach, then click on Upload and then on Close this Window to return to the Edit window. When you have finished composing your post, click on Submit Post. Don't try to use the Paperclip icon (Attachments button), as it doesn't work on this forum.

    Hope this helps.

    Pete

  3. #3
    Forum Guru Bo_Ry's Avatar
    Join Date
    09-10-2018
    Location
    Thailand
    MS-Off Ver
    MS 365
    Posts
    7,211

    Re: View Table based on drop down list selection

    I'm not sure this is what you want,
    Please try this at B21 drag down to B26
    =INDEX(INDIRECT($R$1),ROWS(B$21:B21))

  4. #4
    Forum Guru Pete_UK's Avatar
    Join Date
    12-31-2011
    Location
    Warrington, England
    MS-Off Ver
    Office 2019 (still learning)
    Posts
    24,604

    Re: View Table based on drop down list selection

    Just a slight change to Bo's formula in B21:

    =IFERROR(INDEX(INDIRECT($AG$1),ROWS($1:1))&"","")

    then you can copy it down your yellow area.

    Hope this helps.

    Pete

  5. #5
    Registered User
    Join Date
    09-20-2018
    Location
    New Zealand
    MS-Off Ver
    2016
    Posts
    4

    Red face Re: View Table based on drop down list selection

    Pete_UK & Bo_Ry,
    Thanks very much.

    both solutions work perfectly!

    I'd spent a few hours looking online for a solution and didn't get anywhere, so your help is very much appreciated!
    cheers
    vin

+ 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: 10
    Last Post: 04-03-2018, 02:27 PM
  2. [SOLVED] VBA to Amend the Filter Selection on a Pivot Table Based on a Drop Down List
    By The_Snook in forum Excel Programming / VBA / Macros
    Replies: 9
    Last Post: 03-22-2017, 10:00 AM
  3. [SOLVED] Clear up to three dependent drop down lists based on selection in superior drop down list
    By theletterh in forum Excel Programming / VBA / Macros
    Replies: 9
    Last Post: 03-04-2016, 09:31 PM
  4. Replies: 2
    Last Post: 12-10-2014, 12:42 AM
  5. Replies: 2
    Last Post: 07-15-2014, 08:24 PM
  6. Populate Drop-down list based on selection from previous drop-down list
    By Diventus in forum Excel - New Users/Basics
    Replies: 14
    Last Post: 01-11-2013, 10:55 AM
  7. Populate Drop-down list based on selection from previous drop-down list
    By poison_stone in forum Excel - New Users/Basics
    Replies: 3
    Last Post: 12-11-2012, 06:10 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