Find and Replace Loop + a Loop to remove Duplicate values

Hi all,

I am looking to do a Find Replace Loop to replace a string for another string

In Sheets “Database” I have data from Range I19 downwards, range currently goes to I1828 but as we add more data it becomes larger. I was hoping to get a code that Finds the text “POP125 Index” and replace
whatever row that it FINDS this in column E for “AIU8”. So it searches for the string in I and replaces whatever value is in E of that row for AIU8 The thing is the String “POP125 Index” found anywhere in column I19 onwards also has random text in it like Sept 18, or Aug 19 at the end of it, it could be total random, so the search can’t be an exact match.

Anyone have an idea?

Also I have unique codes in column N, I would like a loop that can scan through column N (data again is N19 downwards) and if it finds a duplicate value it deletes the Row entirely.

Any help is much appreciated.