how to find and replace

[jkpd2000]

hi ,

i have two columns
i want to find a value in one column and put a value in the second column. like that for enitre worksheet

thx

 

[almagg]

i am going to assume that you have only two columns. start with the first cell in the first column selected, then:

do until activecell.value = ""
if activecell.value = variable1 then
activecell.offset(0,1).select
activecell.value = variable2
activecell.offset(1,-1).select
else
activecell.offset(1,0).select
end if
loop

of course variable1 and variable2 can change depending on what you are looking for from the source worksheet and what you are going to enter into the target.
hope this helps.
al