J
JohnUK
Hi,
I am after a piece of code that can replace words from one tab to the next
For example:
Sheet1 - pick up the first word from the Wrong Column(“Wrong1â€) to find and
replace that word in Sheet2 with the correct word found in the Correct column
in Sheet1(“Correct 1â€)
Then keep going until it reaches the last word within the Wrong column of
Sheet1
Wrong Column Correct Column
Wrong 1 Correct 1
Wrong 2 Correct 2
Wrong 3 Correct 3
Wrong 4 Correct 4
Wrong 5 Correct 5
Wrong 6 Correct 6
Wrong 7 Correct 7
My goodness, I hope that makes sense
Help greatly appreciated
Regards
John
I am after a piece of code that can replace words from one tab to the next
For example:
Sheet1 - pick up the first word from the Wrong Column(“Wrong1â€) to find and
replace that word in Sheet2 with the correct word found in the Correct column
in Sheet1(“Correct 1â€)
Then keep going until it reaches the last word within the Wrong column of
Sheet1
Wrong Column Correct Column
Wrong 1 Correct 1
Wrong 2 Correct 2
Wrong 3 Correct 3
Wrong 4 Correct 4
Wrong 5 Correct 5
Wrong 6 Correct 6
Wrong 7 Correct 7
My goodness, I hope that makes sense
Help greatly appreciated
Regards
John