Apologies for not including my actual document. I was planning to use a simplified example just to get the fundamental template of the code by which I can modify myself. I've know attached the JQ Report which I am planning to use the macro on. Now to answer your question:

1. The doc contains only a single large table and has no merged cells.
2. The disparity in columns is simply because I was using a simplified example to avoid bothering other people with unnecessary data.
3. Yes, all these macros should only take effect ONLY IF the first condition (That "Q.J." string is detected on first column) is met and will only be applied to that particular row only.
4. Yes, the " c." should only be replaced if the initial condition is met (That "Q.J." string is detected on first column) and if the " c." is a separate entity with a space before it. For example, in the string "(CIUSSS MCQ) c. R.F."

To review, using my real world attached document's real column names:
I would like the macro to set an initial condition: in JQ column – search
"Q.J." and replace with "J.Q." and in that row's short case name column, change the "c." to "v." also, again in that row, insert the word “English” in the judge(s) field column.


I hope this answers your question. Apologies for taking your time. This is part of my work and I've already sorted out other macro functions which are outside of the original post. So these are the only ones I'm having trouble with. Thanks again.

Attached Files

JQ Report.doc (324.5 KB, 7 views)