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

[nobodyNZ]

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,

[StephenR]

Try this:

Please Login or Register  to view this content.

[nobodyNZ]

Hi StephenR,

Thanks for your reply.
I've tested your code but nothing happens. Am I missing something here?
Please Help,

Thanks Guys

[Philb1]

If you change

Please Login or Register  to view this content.

To

Please Login or Register  to view this content.

it works

[nobodyNZ]

Hi Phib1,

Thanks man. It works like a Charm !!!
Thanks a lot for your helps guys.

Problem is solved.