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

 

[PaddyD]

more info please! what are you trying to find? want to do it with formulas or VBA etc...

paddy

 

[jkpd2000]

anything which works for me.

ex.

col1 col2
A
B 10
C
B 10
B 10
A
C

suppose i have to search for B and replace 10
it should look like the above

 

[PaddyD]

on the assumption that something of the form

=if(a1="B",10,"")

isn't what you need, more info again!

paddy

 

[jkpd2000]

yes, but it should do for all the rows where ever B is there.

i am writing in vba. i am getting a value in one worksheet and putting it another worksheet searching for that column value B and putting value where ever B is there in that column
This message was edited by jkpd2000 on 2002-10-30 16:38

 

[jkpd2000]

yes, but it should do for all the columns where ever B is there.

i am writing in vba. i am getting a value in one worksheet and putting it another worksheet searching for that column value B and putting value where ever B is there in that column

 

[jkpd2000]

yes, but it should do for all the columns where ever B is there.

i am writing in vba. i am getting a value in one worksheet and putting it another worksheet searching for that column value B and putting value where ever B is there in that column

 

[jkpd2000]

paddy,
did you get it what i am trying to do ?

 

[Jim North]

It sounds like a simple VLOOKUP function would do it. What are you doing in VBA... would you post it to the board so we can look it over?

 

[PaddyD]

Not really, especially given the "all the columns" remark - I assume you don't mean all 256 available columns. you'll really need to be more specific. please post back with a complete, worked example. if the code you're using is relevant, post it up.

paddy