+ Reply to Thread
Results 1 to 6 of 6

Making a Dropbox from a Datatable

  1. #1
    Registered User
    Join Date
    05-06-2014
    Location
    Cincinnati
    MS-Off Ver
    Excel 2010
    Posts
    3

    Making a Dropbox from a Datatable

    Below is a Problem that I have been working on for a few weeks but can not seem to figure it out. I am a Coach who will be using this data table to call pitches via a catcher's wristband. The band is obviously completed below; however, I need to create a separate sheet where the numbers correlate to the pitches that are being called. How it works: everything in the table(s) with a dash is a pitch i.e. 2-1, 1-3, 1-U, etc. The numbers on the columns and row are what is relayed to the catcher to call the corresponding pitch. For example, I would signal is 113 (first number = row second number = column). 113 is 4-1. I need a way/ formula to where I can see which numbers are to be relayed in for each pitch. It would possible look like 2-1: 101, 411, 422, 501, etc. Hopefully someone can understand this and help me! Thanks.


    Catching Wristbands.xlsx
    Last edited by jforr15; 05-07-2014 at 01:30 PM.

  2. #2
    Forum Guru MarvinP's Avatar
    Join Date
    07-23-2010
    Location
    Woodinville, WA
    MS-Off Ver
    Office 365
    Posts
    16,164

    Re: Baseball needing Excel Assistance!

    Hi and welcome to the forum,

    I think I understand that you will signal the catcher and he will tell the Pitcher what to throw. You have lots of dups in your table.

    See if the attached helps. You simply double click on a pitch and it will highlight in your table, so you can then find them fast to relay. I have no idea if this is what you are looking for..
    Attached Files Attached Files
    One test is worth a thousand opinions.
    Click the * Add Reputation below to say thanks.

  3. #3
    Registered User
    Join Date
    05-06-2014
    Location
    Cincinnati
    MS-Off Ver
    Excel 2010
    Posts
    3

    Re: Baseball needing Excel Assistance!

    Thank you a lot! This helps a lot more than what I was getting at. Would there be any way to make some sort of drop down box of pitches and have the corresponding numbers pop up?

  4. #4
    Administrator FDibbins's Avatar
    Join Date
    12-29-2011
    Location
    Duncansville, PA USA
    MS-Off Ver
    Excel 7/10/13/16/365 (PC ver 2310)
    Posts
    52,917

    Re: Baseball needing Excel Assistance!

    Hi and welcome to the forum

    Please take a moment to read the forum rules and then amend your thread title to something descriptive of your problem (think google search terms?). Once you have done this please send me a PM and I will remove this request. (Also, include a link to your thread - copy from the address bar)

    To change a Title on your post, click EDIT POST then Go Advanced and change your title, if 2 days have passed ask a moderator to do it for you.
    1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
    2. If your question is resolved, mark it SOLVED using the thread tools
    3. Click on the star if you think someone helped you

    Regards
    Ford

  5. #5
    Registered User
    Join Date
    05-06-2014
    Location
    Cincinnati
    MS-Off Ver
    Excel 2010
    Posts
    3

    Re: Making a Dropbox from a Datatable


  6. #6
    Administrator FDibbins's Avatar
    Join Date
    12-29-2011
    Location
    Duncansville, PA USA
    MS-Off Ver
    Excel 7/10/13/16/365 (PC ver 2310)
    Posts
    52,917

    Re: Making a Dropbox from a Datatable

    ummm that link is to this thread?

+ 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. Needing Assistance with a Nested Vlookup Statement
    By JeffLively in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 04-16-2014, 07:51 PM
  2. [SOLVED] Excel novice needing assistance with cumulative totals
    By jlwhitten in forum Excel General
    Replies: 5
    Last Post: 04-13-2014, 08:41 AM
  3. Newbie needing assistance
    By Woodchuck75 in forum Hello..Introduce yourself
    Replies: 1
    Last Post: 07-22-2012, 11:33 AM
  4. baseball program on excel
    By sanmania in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 12-21-2007, 01:44 AM
  5. [SOLVED] mathematician dummy needing assistance
    By [email protected] in forum Excel - New Users/Basics
    Replies: 2
    Last Post: 11-21-2005, 05:10 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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1