Good afternoon Forum!!!

I am trying to create a code that will look in the cells in column "G" that contains specific text and then paste that in corresponding cell in column "C".

Ex.

G4 contains MC75-Device(which is the criteria searching for), then paste "MC75-Non Store Device" in C4.

I think that I can modify this code to make this happen but not really sure how...

Dim ws As Worksheet
Dim c As Range
Set ws = ActiveSheet

For Each c In ws.Range("G2:G" & ws.Cells(ws.Rows.Count, 1).End(xlUp).Row)
        If c.Value = "" Then c.Range("G2:G" & Cells(Rows.Count, "G").End(xlUp).Row).Replace vbLf, ""
    Next c
This code is looking for exact text and I would like to find the cell that contains a specific string but may not be the exact or full string of text and then paste a specific text in column C.

Suggestions??