I am getting quite frustrated with this, so any help is very much appreciated
I have included an excel with my questions
1) How do I search the Text of Cell in a range and return the whole cell where content is found
2) How do I search a string of text in a range and return the whole cell where content is found
Many Thanks!
Bookmarks