Hi
I need a macro that searches for a word in a row and once if it finds the word then it should check the cell values of entire column below that row and if the cell value matches with the sheet name it should mark an error message

NOTE: It should be applicable to entire work sheet like if a Macro is Executed it should search all the sheets at a time and popup an error message for specific cell

Any help will be appriciated