Search Function to Filter information

[damaniam]

Sorry for the vague title. The macro needed is a bit specific.

So what I'm looking for is the have the macro search Column A for the word total. Once Found look at column K. If K>0 then do nothing if K=0 then I'd like the macro to hide the row containing total as well as all rows between it and the previously occurring blank cell in column A. Sorry if that was a bit confusing but I hope the description and the attached file make sense.


Sanitized Report.xlsx

[ragulduy]

Please Login or Register  to view this content.

?

[damaniam]

Worked as requested. I think I might foresee some limitation to my requests. If I have any further changes request I'll ask here. Thanks again for the help.

[damaniam]

So after running the macro a couple of times, I found an error in my request. If K>0 part is right, but I also need it so that if K>0 and if "E" for each section (bold total to previous blank row) contains "(" or ")" then I need it not hidden as well. Thanks again for the previous help and if you need a better explanation let me know.