Finding a Value and inserting a value in another cell

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
Do you mean

=IF(F2>0,"new data","")

and copy to all relevant rows

--

HTH

RP
(remove nothere from the email address if mailing direct)
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

VBA - retrieve data on last create named range from previous inserted named range 0
Insert row with a locked cell 1
how to automatically update a second worksheet when data inserted 2
Add a new row in Named Table (Table1) and add data from txtboxes into last empty cells based on header named of the Table1 0
Hide columns based on row values 2
Overwrite All Cells in Column 2
Insert a cell value into a link to another worksheet. 10
Excel Copy cells from one worksheet to another workseet - increment row & do again 0

Back
Top