Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Multiple Criteria Find & Replace
Wondering if there is a script out there that can find and replace
multiple cells with different criteria. Example: Worksheet tab 1: Columns A B Red 1 Green 2 Blue 3 Worksheet tab 2: Columns A B C 1 1 3 2 1 2 2 3 1 After macro/script, we would have replaced the numbers in Worksheet tab 2 with the words from Worksheet tab 1, so Worksheet tab 2 would look like this: Worksheet tab 2: Columns A B C Red Red Blue Green Red Green Green Blue Red Thanks for any help! Al |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
multiple find and replace | Excel Worksheet Functions | |||
Customized Find/Replace to Update Numbers Using Specified Criteria | Excel Discussion (Misc queries) | |||
Multiple find mulitple replace | Excel Worksheet Functions | |||
Find/Replace in multiple worksheets | Excel Discussion (Misc queries) | |||
Multiple Find and Replace in one function | Excel Worksheet Functions |