Filter by color and sort Z-A with VBA

[Legs]

Afternoon

I am trying to filter a column by a color and then sort it Z-A once it has been filtered. Is this possible with VBA? I am trying to automate my sheet as much as possible so users don't have to sort and filter manually where possible. The column I am working with is I:I.

Many thanks in advance.

[zbor]

Insert filter.
Sort I column descending.
And then filter out color you want.

It's just one click you trying to avoid (sortin) that you will replace with another click (macro)?

[Legs]

Insert filter.
Sort I column descending.
And then filter out color you want.

It's just one click you trying to avoid (sortin) that you will replace with another click (macro)?

It is easy to do however not everyone knows excel (or how to use a mouse). I have automated the rest of my sheets with VBA for things like filtering out blank rows and this is currently the only sheet that needs manual work. The sheet will have new data in every day and have to be set up be several people some of whom struggle with excel, hence the atomisation.

[zbor]

How about this:

In I column, whatever cell you click it will sort and filter that color.
If you click anywhere else it will remove filter.