In Column A I have the name of a staff member. This is a merged cell spread out over many rows such as Peter in one merged cell from Rows 7:11, Andy in Rows 13:17, Peter in 19:23 etc.
Each staff member will have a button on the spreadsheet. When it is pressed it needs to hide all rows without that name in.
So, if the spreadsheet is fully displayed and I select "Peter" it should then hide every row (between 7 and 100 for now) that contains any other name bar Peter (so in effect it will only show Peter's records. (Rows 7:11, Rows 19:23 in example above will show, and rows 19:223 will be hidden).
There will be a separate button to unhide all records. (I appreciate this can be done by a filter, but to limit access so if possible this will be a locked and protected sheet without autofilter being available)
It will be a bonus if you do not have to "Show All" before selecting another name. So, if I had Peters records up, and then clicked on Andys it will do this, without having to click on a separate button to show all first
Thanks in advance!
Each staff member will have a button on the spreadsheet. When it is pressed it needs to hide all rows without that name in.
So, if the spreadsheet is fully displayed and I select "Peter" it should then hide every row (between 7 and 100 for now) that contains any other name bar Peter (so in effect it will only show Peter's records. (Rows 7:11, Rows 19:23 in example above will show, and rows 19:223 will be hidden).
There will be a separate button to unhide all records. (I appreciate this can be done by a filter, but to limit access so if possible this will be a locked and protected sheet without autofilter being available)
It will be a bonus if you do not have to "Show All" before selecting another name. So, if I had Peters records up, and then clicked on Andys it will do this, without having to click on a separate button to show all first
Thanks in advance!