+ Reply to Thread
Results 1 to 12 of 12

Hide Used Items in Drop Down List

Hybrid View

  1. 08-05-2015, 10:18 AM #1
    windy58
    windy58 is offline
    Forum Contributor
    Join Date
    03-17-2005
    Location
    Canterbury, Kent
    MS-Off Ver
    2003, 2010
    Posts
    285

    Re: Hide Used Items in Drop Down List

    How about this...

    Have created named ranges for each group plus one covering all remaining players.

    Have added message to data validation which appears when a cell is selected.

    Windy
    Attached Files Attached Files
    Reply With QuoteRegister To Reply
  2. 08-05-2015, 10:32 AM #2
    fffleague15
    fffleague15 is offline
    Registered User
    Join Date
    07-30-2015
    Location
    England
    MS-Off Ver
    365
    Posts
    32

    Re: Hide Used Items in Drop Down List

    Quote Originally Posted by windy58 View Post
    How about this...

    Have created named ranges for each group plus one covering all remaining players.

    Have added message to data validation which appears when a cell is selected.

    Windy
    Hi mate I really appreciate it but it gets confusing for me looking at that. I would rather use ChemistB's technique but if I can't then I will use yours mate. Thank you.
    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] Hide Rows based off items from a ComboBox List.
    By Glitch_ in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 10-17-2014, 09:27 AM
  2. Hide used items in drop down list & select multiple items in a drop down list
    By philip.michael.smith in forum Excel General
    Replies: 0
    Last Post: 04-22-2014, 11:03 PM
  3. Items used from a drop down list
    By vanmeterkj in forum Excel General
    Replies: 3
    Last Post: 05-17-2012, 01:50 AM
  4. Excel 2007 : Pivot table drop down filter - hide / delete items
    By Johan Nel in forum Excel General
    Replies: 0
    Last Post: 08-07-2010, 04:13 AM
  5. [SOLVED] Hide previously used items from multiple drop lists
    By ron in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 04-25-2006, 02:55 PM
  6. Hide previously used items from multiple drop lists
    By ron in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 02-27-2006, 05:20 PM
  7. [SOLVED] Hide previously used items from multiple drop lists
    By ron in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 02-22-2006, 02:45 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