Good day,

I would like to know how to do a macro that occurs only on a specific row IF a that row's first column has the string "Q.J." inside it.

For example, if we have this table:


Column 1 Column 2 Column 3
2021-Q.J. Short-Case-Name-c. Doe-Clapton
2021-A.K. Short-Case-Name-v. Doe-Clapton-french
2020-T.J. Short-Case-Name-v. Doe-Clapton-english

I would like the macro to find for the string "Q.J." in the entire table's first column.
If it finds "Q.J.", I would like to have the following changes applied to that specific row only:

1. replace "Q.J." with "J.Q."
2. replace the string "c." in column with "v."
3. insert the string "english in column 3

This would the result:
Column 1 Column 2 Column 3
2021-J.Q. Short-Case-Name-v. Doe-Clapton-english
2021-A.K. Short-Case-Name-v. Doe-Clapton-french
2020-T.J. Short-Case-Name-v. Doe-Clapton-english

I've also attached a screenshot of the real world document where I will be using the macro.

I hope you could help me on this one.

Thanks!

Attached Images

macrohelp.png (56.6 KB, 16 views)