+ Reply to Thread
Results 1 to 2 of 2

Hide Drop down list items across multiple pages.

  1. #1
    Registered User
    Join Date
    01-18-2024
    Location
    Moon
    MS-Off Ver
    365
    Posts
    2

    Question Hide Drop down list items across multiple pages.

    Hello,

    New here. I was wondering if anyone had a dynamic way to hide drop-down items that can selected from different sheets?

    Example: List of company EEs assigned to different projects. Each sheet would be a separate project. There is a master EE list to reference for drop-down list. I can get it to filter on single sheet using COUNTIF function. Attempting to use VSTACK, just need a little help.

    Any suggestions?

    Thanks,

    Morgan

  2. #2
    Administrator 6StringJazzer's Avatar
    Join Date
    01-27-2010
    Location
    Tysons Corner, VA, USA
    MS-Off Ver
    MS365 Family 64-bit
    Posts
    24,721

    Re: Hide Drop down list items across multiple pages.

    Your description is not concrete enough to give you a solution you can plug in. Not sure exactly what you want to hide. It will be a lot easier to understand what you're doing if you attach a sample Excel file. See yellow banner at the top of the page.

    Also welcome to the forum, but please do not populate your profile with jokes. We ask for location so we can understand what Excel localization you are using and possibly time zone for communication purposes. If you don't want to give your city, tell us the state/province, or at least the country.
    Jeff
    | | |會 |會 |會 |會 | |:| | |會 |會
    Read the rules
    Use code tags to [code]enclose your code![/code]

+ 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. [SOLVED] Hide Used Items in Drop Down List across multiple sheets
    By Matthew2 in forum Excel General
    Replies: 10
    Last Post: 01-19-2024, 12:39 AM
  2. [SOLVED] Hide Used Items in Drop Down List
    By Ramesh h&m in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 06-18-2023, 01:17 AM
  3. Hide Tabs Based on the choice of Multiple Items from Drop Down List
    By knopp in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 10-21-2021, 03:12 PM
  4. Replies: 0
    Last Post: 07-12-2020, 02:18 AM
  5. Hide Used Items in Drop Down List
    By fffleague15 in forum Excel Formulas & Functions
    Replies: 11
    Last Post: 08-05-2015, 12:10 PM
  6. Replies: 0
    Last Post: 04-22-2014, 11:03 PM
  7. 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

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