Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
find&replace macro
i need some help looking and replacing some stuff up...i cant seem to
come up with a combo of functions that work. what about a macro? I need to find A1 in column B, then replace that cell in B with the corresponding value in C1. (the find and replace in edit is soo tediuos for 500+ searches) A B C 1 5 9 33 2 6 3 41 3 9 6 423 4 5 5 7 i want something like this: A B C 1 5 423 33 2 6 3 41 3 9 41 423 4 33 5 7 can someone help me! =o( |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Search, Copy, Paste Macro in Excel | Excel Worksheet Functions | |||
Can T Get Macro To Run! | New Users to Excel | |||
Closing File Error | Excel Discussion (Misc queries) | |||
Help with macro looping and color query function | Excel Discussion (Misc queries) | |||
Date macro | Excel Discussion (Misc queries) |