Button to choose A/B/C values from one column & show them all

[Tsinos]

G- column indentifies different locations per row. G5 can have value "London", G6 can be "Frankfurt", and G7 "Manchester" etc.
If the user would only want to see rows that are related to London, it should be able to do with a button click, which would filter the G-column results. Or if the user would like to see "Frankfurt" related rows, it should be filtered by a click of button.

Manually filtering is possible but to make it easy for the user, how should I do it? I want the user to be able to:
- filter per one city
- clear the filtering , so that all the cities -> rows can be seen.

Is that done with VBA and if so, what kind of code should I try? I've done one VBA previously so please response as you would for a total beginner. I do know how to assign the VBA to a button but the code - alert box or similar??

Could this be solved with one button, with four options "London", "Frankfurt", "manchester" and "clear filtering".
Thank you .

[Logit]

Please Login or Register  to view this content.

[Tsinos]

Thank you Logit! I did not know that is possible! One final question, can the filtering be done so that it searches only based on three first letters of the City? Partial match.
Can there be a universal solution as when manually filtering there is an option "begins with".

[Logit]

.

Please Login or Register  to view this content.

Column Headers in ROW #1

Data begins in ROW #2

[Tsinos]

Fantastic! Now it works like a dream. Thank you for your input!

[Logit]

Glad to help.