How to do row specific macro only if column criteria is met
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!
|