Remove data after last occurance

[cmb80]

Hello, I have attached an example sheet.

In K1 I have a value

What I want a macro to do is search for the LAST occurrence of this in column A - and clear all data after it.

So in this instance column A would match what is in Column O

[Leith Ross]

Hello cmb80,

This macro will do what you want.

Please Login or Register  to view this content.

NOTE: Because this is a Partial Match, you should include the Parentheses. E.g. the value in K1 should be (AUS).