Find text in all rows of column and input text into cell next to it

**Empumpu** · 09-30-2015, 04:37 PM

Hello,

I've been fighting with this problem for a while now. I want some kind of add in, or something to help my project. So I have these Excel tables, over 15 000 lines of text in three columns. I want add in to do this:

- finds text I want (ie. "date of introduction") in all rows of column B
- inputs text I want (ie. "08/08/2015") in the row next to it in column C
- finds every row that contains text I am looking for and inputs all rows next to them automatically, so I the function doesn't have to be physically in the cell.

Hope this isn't too complicated text to read and thanks for all the help!

**skywriter** · 09-30-2015, 04:41 PM

Attach a sample workbook. Make sure there is just enough data to demonstrate your need. Include a BEFORE sheet and an AFTER sheet in the workbook if needed to show the process you're trying to complete or automate. Make sure your desired results are shown, mock them up manually if necessary.

Remember to desensitize the data.

Click on GO ADVANCED and use the paperclip icon to open the upload window.

View Pic

**Empumpu** · 09-30-2015, 05:03 PM

Okay, added sample. It's in finnish, sorry for that. But what I want basically, is to find the text desired ("Käyttöönottopvm. (pp.kk.vvvv)") and input in the cell next to it the date. This is just one example.

Hope this is what you meant to do.