Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Find a value in one cell and Replace in another cell
Is there a way to Find a value in one cell and Replace in another cell? I
want to find a value in a column and replace a value in another column on the same row. Is this possible? Mike |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Find a value in one cell and Replace in another cell
Set cell = Columns(1).Find("somevalue")
cell.value = Cells(cell.Row,"J").Value will replace it with the contents of column J. -- --- HTH Bob (there's no email, no snail mail, but somewhere should be gmail in my addy) "Archangel" wrote in message ... Is there a way to Find a value in one cell and Replace in another cell? I want to find a value in a column and replace a value in another column on the same row. Is this possible? Mike |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Find comment replace cell value | Excel Discussion (Misc queries) | |||
How Do I find/replace a blank cell with a formula? | Excel Worksheet Functions | |||
How do you find and replace tab characters in a cell in Excel? | Excel Discussion (Misc queries) | |||
Find & replace a value in an unknown cell location | Excel Discussion (Misc queries) | |||
find and replace does not work in a linked cell | Excel Discussion (Misc queries) |