Hi I'm using Excel 2016. I'm trying to find a way to look for a value and when that value is found on any row paste a predefined value into column D on that same row. Here is pic to give you an idea if I didnt explain it well. I want the script to find any row with "hey you found me" and on that same row in Column D, put "predefined value".
