Forum Discussion

imba boy95's avatar
imba boy95
Copper Contributor
Sep 25, 2017
Solved

Help! Macro edit multi-cells with conditions. Thank all of you!

Hi, i am student, i need Macro to edit about 3000 quizzies like that ( i edited about ~ 200 quizzes). You can see below, every question contain { content } . I need { } is first variable to define as range to replace content in { } and Answer (A) or Answer (B/D/D) are 2nd variable to define. 

Exp: 

1. We defined Question 1 have { } and next we find in {} contain Answer (B) now Macro will replace (B) One year to 
/=(B) One year. Replace Other choice (A/C/D) to ~(A) Many years ~(C) Until next month ~(D) Today

Question 1. For how long can this product be enjoyed?
{
(A) Many years
(B) One year
(C) Until next month
(D) Today
####
Answer (B)
More: asd qwe eiquwei oquwoe uqiw ueqio quweo iqwuoe
}

----------After running Macro--> 
Question 1. For how long can this product be enjoyed?
{
~(A) Many years
/=(B) One year
~(C) Until next month
~(D) Today
####
Answer (B)
More: asd qwe eiquwei oquwoe uqiw ueqio quweo iqwuoe
}

-------------------------------------------------------------------------------
2. We defined Question 2 have { } and next we find in {} contain Answer (C) now Macro will replace (C) Four to /=(C) Four

Question 2. How many different sizes does the product come in?
{
(A) A variety
(B) Two
(C) Four
(D) One for each customer
####
Answer (C)
More: 123 13 1 4 1j4 k1jl4kj 1kl3 1k23jl1
}

------------After running Macro--> 
Question 2. How many different sizes does the product come in?
{
~(A) A variety
~(B) Two
/=(C) Four
~(D) One for each customer
####
Answer (C)
More: 123 13 1 4 1j4 k1jl4kj 1kl3 1k23jl1
}
------------------------------------------------------------------


Thank all of you!

Resources