Results 1 to 12 of 12

Hide rows based on status and dropdown list

Threaded View

  1. #1
    Forum Contributor
    Join Date
    02-29-2012
    Location
    UK, Newcastle
    MS-Off Ver
    Office 365
    Posts
    130

    Hide rows based on status and dropdown list

    Hi, I have column M representing the current of tasks. Example NS. WIP, COMPLETE, HOLD.
    The rows already change to green when complete but they take a lot of space up on screen.
    I would like a drop down list at top of sheet to choose what is shown and the rest will be hidden.
    So The Drop list called Show Tasks would have choice of NS, WIP, COMPLETE, ALL, OPEN, HOLD.

    NS shows only status of NS and hides all other.
    WIP same for status WIP.
    COMPLETE, same for COMPLETE.
    ALL would show (unhide all rows).
    OPEN would shown NS, WIP and HOLD.

    The sheet will be shared so, if possible I would like this to apply to only the sheet I am viewing and not others may be viewing at same time.
    Even though any actual change to data would update instantly on all.
    This would be nice but if it has to effect all sheets thats ok.
    The icing on the cake would be that everytime a user opened the sheet it would default to a choice they had set as default.
    So user A may choose to view all ROWs when opening and user B may choose to have only OPEN rows.
    Again nice to have but the original request of dropdown list for hiding rows is the main requirement.
    Last edited by maax555; 02-07-2025 at 06:46 AM.

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Display/hide rows based on dropdown list
    By Najz420 in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 12-09-2021, 02:20 PM
  2. Replies: 3
    Last Post: 06-23-2020, 11:30 AM
  3. Hide Rows based on the value in a dropdown cell
    By cajunlibra in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 10-08-2016, 11:00 AM
  4. Hide/Unhide rows based on Yes or No answers to questions by dropdown list.
    By Johny1 in forum Excel Programming / VBA / Macros
    Replies: 11
    Last Post: 02-12-2015, 06:57 PM
  5. [SOLVED] VBA to hide cells based on dropdown list using If/Else/Then
    By JOHNROK in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 07-30-2012, 06:13 PM
  6. Hide Rows based on dropdown list in another sheet
    By Jeeperman4x4 in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 05-04-2011, 08:01 PM
  7. Hide Rows based on dropdown selection...
    By hutch@edge.net in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 06-27-2008, 04:09 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