| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Find and Replace
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 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Find and Replace - Replace with Blank Space | Excel Discussion (Misc queries) | |||
| Find/Replace Event or Find/Replace for Protected Sheet ... | Excel Programming | |||
| find and replace - replace data in rows to separated by commas | Excel Worksheet Functions | |||
| Using Find and Replace to replace " in a macro | Excel Programming | |||
| Replace method - cannot find any data to replace | Excel Programming | |||
Threaded Mode
