Hi,
I have searched online for a macro that would do this but found no luck.
What I want to do is identical to a simple filter but if possible I would like this to be a macro which is constantly running and would update based on cell criteria.
The two input cells on the attached are:
AB6 (The Project)
AF6 (The resource)
What I would like is the rows hidden (from and including row 9 and below) hidden if they do not match the criteria
e.g. if Project 2 and Person 2 is selected then it would only show row 18
e.g. 2 if Project 3 is selected (and resource left blank) it would show only rows 25-32
Can anyone help with the code?
If possible I need it to run all the time but if need be I can create a button
Bookmarks