If text is found, move it to another cell + delete that row.

Hi Guys,

I need a VBA coding to do the following:
If a cell in Column C contain certain text, then move that cell 1 up 1 right. For example: If the word "No Offer" is found in Cell C3, move it to cell D2. Then Delete row C3.

Thanks Guys,