Deleting Cell value the cell in the next column is the same

I am trying to have a VBA clean up and format data every time a table is refreshed. There are two columns that I want to look at. one is Job #, and the next one is Top level Job #. I would like the vba to look at column E, and if E5 = D5, then delete the contents in E5. If they are not the same, keep the content in E5. I would like it to do that for however many rows in Column E there are, as this will constantly change. If more information is needed let me know.