Quote:
Originally Posted by Guessed
Typically when people put in requests like this without providing a realistic sample document, the initial solutions don't fit because of things that aren't said. If you provided a sample doc you would get a much better solution since we can test the macro without having to make assumptions.
The specific questions I would need answered first are: - Do your tables contain any merged cells?
- Your text says add 'english' to column 3 but your screenshot shows it in column 10. Which is correct?
- Does the c./v. replacement happen anywhere in the row or only in a specific row?
- Does the c./v. replacement happen only when there is a space in front of the c.?
|
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.