I have an extended question. I realize this code will find only one column of "Supplier" whereas there are situations where the condition "Supplier" happens in more than one column. I tried to change the code but I failed. Sorry to bother you.Hi ,
See this revised file. The header labels will have to be in row 1.