Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Finding a Value and inserting a value in another cell
I would like to know if it is possible to find data from a column and insert
new data in an other column if there are positive results. This would be similar to a Find and replace function, but it would not replace the searched data. This has to be done several times through out the worksheet with different data being inserted in the other column |
#2
|
|||
|
|||
Do you mean
=IF(F20,"new data","") and copy to all relevant rows -- HTH RP (remove nothere from the email address if mailing direct) "Craig" wrote in message ... I would like to know if it is possible to find data from a column and insert new data in an other column if there are positive results. This would be similar to a Find and replace function, but it would not replace the searched data. This has to be done several times through out the worksheet with different data being inserted in the other column |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|