Using vba coding to change text
 

Hello,

Currently I have a workbook call "Coding" that has vba coding to change
certain things in a particular workbook called "Credit Adjustment" What I
want to do is to change the text based on a particular text from a cell.
For example in cell A7 I will have in that cell text "Mark" in cell G7 I
want the text of that cell change to "Report" otherwise change the cell text
to "Error". Now the rows may vary in the "Credit Adjustment" workbook in a
month I may have 200 rows in another month 500 rows. Can anyone help me.
Any tips or website to visit I will appreicate. Thank you in advance.

Cheers