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.

The drop-down list of options is a standard feature of Excel's filtering - select that one column, choose Data / Filter and the header at the top of the column will have a dropdown selector where you can choose. Simple to apply, and probably the easiest solution for everything if you just teach your other users how to select what values they want to see in that column.

Hi Bernie, thanks. However its the rows I want hidden not he columns. It doesn't have to be a drop down list a macro button for each would also work.

EDIT- I have now found a post with my exact requirements and is along the lines you mentioned. Unsure why this did not come up in my original search.

Filtering hides rows, which is what you described as your requirement. Follow my suggestion and it should work fine.

I assume your minor issues are

1) when I choose all I dont see all of the rows. I used the same technique as another post which works for all.
2) When I choose various views using the dropdown list I want the results to be returned so they are viewable on screen without having to use scroll.

1) o see all, use "Clear filter from...." which appears when you click the filter dropdown.

2) IF you have a lot of data, then you have to scroll to see it (or change the zoom)

It appears that the drop down in cell R1 should activate some code (VBA).
I don't know enough about VBA to be of any help there however I will offer two suggestions:
1. It would probably be useful to show a link to the thread alluded to in post #3
2. It would be useful to ask an administrator/moderator to have this thread moved to the VBA forum
I hope that you have a blessed day.

Originally Posted by maax555

Unsure how to request moderator to move, sorry.

To send a request to moderators, please click the Report Post button under the relevant post. You will then get a screen to describe what you want to report/request. Someone has seen your post and has already done this. I have moved the thread.