+ Reply to Thread
Results 1 to 8 of 8

dropdown that simultaneously crosses off the name from the original list

  1. #1
    Registered User
    Join Date
    02-12-2014
    Location
    New York
    MS-Off Ver
    Excel 2003
    Posts
    4

    dropdown that simultaneously crosses off the name from the original list

    How do I automatically cross off (strike through) an item from the original list after it has been selected from a drop down?

    I have a sheet for each position (i.e. "1B", "2B", "3B", "OF", etc.) which has player names and stats and are all formatted the same. I have an additional sheet called 'All Rosters' - that has all 12 teams and their roster. For each position under each team there is a dropdown menu to choose from. I can't figure out how once the player is selected from the dropdown that is simultaneously crosses off the name from the original list.

    I am new to using excel formulas and even less experienced with macros and VBA. I am willing to learn though! Any help is greatly appreciated.
    Attached Images Attached Images

  2. #2
    Forum Expert Mumps1's Avatar
    Join Date
    10-10-2012
    Location
    Toronto, Canada
    MS-Off Ver
    Excel 2010, 2013
    Posts
    7,815

    Re: dropdown that simultaneously crosses off the name from the original list

    It would be easier to help if you could post your file instead of a screen shot.
    You can say "THANK YOU" for help received by clicking the Star symbol at the bottom left of the helper's post.
    Practice makes perfect. I'm very far from perfect so I'm still practising.

  3. #3
    Registered User
    Join Date
    02-12-2014
    Location
    New York
    MS-Off Ver
    Excel 2003
    Posts
    4

    Re: dropdown that simultaneously crosses off the name from the original list

    I attached it. still a work in progress FYI.
    Attached Files Attached Files

  4. #4
    Forum Expert Mumps1's Avatar
    Join Date
    10-10-2012
    Location
    Toronto, Canada
    MS-Off Ver
    Excel 2010, 2013
    Posts
    7,815

    Re: dropdown that simultaneously crosses off the name from the original list

    Just to clarify ... to use an example ... if you choose a name from the drop down list, let's take "Robinson Cano" (2B), do you want to remove his name from the original list in sheet "2B"? This will also remove his name from the drop down list on the "All Rosters" sheet.

  5. #5
    Registered User
    Join Date
    02-12-2014
    Location
    New York
    MS-Off Ver
    Excel 2003
    Posts
    4

    Re: dropdown that simultaneously crosses off the name from the original list

    You are correct. Removing the name will cause too many problems. I was hoping for a that name ("Robinson Cano" (2B)), to be crossed off or maybe to change the font color to red?

  6. #6
    Forum Expert Mumps1's Avatar
    Join Date
    10-10-2012
    Location
    Toronto, Canada
    MS-Off Ver
    Excel 2010, 2013
    Posts
    7,815

    Re: dropdown that simultaneously crosses off the name from the original list

    Copy and paste this macro into the worksheet code module. Do the following: right click the tab for sheet "All Rosters" and click 'View Code'. Paste the macro into the empty code window that opens up. Close the code window to return to your sheet. Make your name selection from the drop down.
    Please Login or Register  to view this content.
    Last edited by Mumps1; 02-20-2014 at 03:27 PM.

  7. #7
    Registered User
    Join Date
    02-12-2014
    Location
    New York
    MS-Off Ver
    Excel 2003
    Posts
    4

    Re: dropdown that simultaneously crosses off the name from the original list

    It works, and exactly what I wanted. Thank you very much. Now maybe I can even learn how you did it!

  8. #8
    Forum Expert Mumps1's Avatar
    Join Date
    10-10-2012
    Location
    Toronto, Canada
    MS-Off Ver
    Excel 2010, 2013
    Posts
    7,815

    Re: dropdown that simultaneously crosses off the name from the original list

    My pleasure. I'm glad it worked out.

+ 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: 0
    Last Post: 08-22-2012, 03:52 PM
  2. Replies: 21
    Last Post: 12-02-2009, 03:27 PM
  3. Triggering Different Dropdowns Based on Original Dropdown
    By Ziilch in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 05-14-2009, 08:09 AM
  4. Date dropdown list and a Time dropdown list in outlook
    By L_ter in forum Outlook Programming / VBA / Macros
    Replies: 3
    Last Post: 03-30-2009, 02:33 AM
  5. [SOLVED] result of selecting from the dropdown list should be a dropdown list
    By No News in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 07-01-2006, 05:55 AM

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