I've been doing crazy searchs to try and find something like this......This is so close to what I'm looking for. How would I modify this script to make it a little more strict. I need to put this in about 100 cells I need it to see if the result is = to 5 if so extract text from Column A (Always) and make a list like this script is doing. I hope that makes sense.
Refers to this post:
http://www.excelforum.com/excel-gene...in-a-cell.html
Bookmarks