Macro to filter data clearing issue

[kingsp]

Hi folks,

I have a macro set up to filter data based on two criteria. The user enters either 'Name' and/or 'Centre Name' to filter data located on another sheet. The 'Name' search works fine but when a 'Centre Name' is entered it clears the entire list of results. I have a 'Clear' button also to clear all the data for a fresh search but I can't see how they might be linked.

If someone could help me to set up the filter properly I would really appreciate it. Sample file is attached.

Many thanks.

Simon.

[AlphaFrog]

On sheet "Data" the header for "Centre Name " (cell F1) has a trailing space at the end which is not an exact match for the header (G4) on the Search sheet.

[kingsp]

That was pretty silly of me. Many thanks AlphaFrog.

[AlphaFrog]

You're welcome.