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!