Search and filter

Apologies if this is posted in the wrong section, I have a feeling though that I will need a Macro to achieve what I'm after.

I have a sheet (example attached) that is populated several times a week. At present I mainly use it but it will also be used by all staff to find relevant notices.

I need to be able

At the minute as you can see there are filters in place and a rudimentary search facility. However constantly having to explain why it's required to have to select the topic "Departments" "Title" etc typing in the search criteria, clicking out of the search box then clicking on "search" is becoming a RPITA.

Is there a way to just search the sheet for any given criteria by typing it in a search box and hitting search (not having to highlight a particular column or have to click out etc first)?

Hope I'm making sense.

As usual all help greatly appreciated.

If you read my pre edited post ignore it. I just saw the ammended sheet. I was just going by your code.

DUH

I am a pratt.

Can there be a refresh or similar button to return to showing all entries.

Once again many thanks for this it really is just what I'm looking for. I appreciate it, there looks like quite some work in your code.