Remove all rows after Value is found in column

Hey,

The macro I'm looking for should be fairly simple but everything I've tried isn't working and I don't know what I'm doing wrong.I need a macro to look at the name in: C2 and search from C3 down to end of page, the we only need to know when it first encounters the name. (C7 in my example) and then it needs to delete that row and other rows below .

So in this example it looks at C2 and finds James Low it searchs and finds James Low on C7 and then deletes the rows from 7 to 21 (A7:D21) (See attachment)

Thanks in advance
- Hyflex