Please see attached workbook.
I need a macro to check each name in range F2:F11 and determine if it exists in MainTable, column 1.
If it does, do nothing. If it does not, call a MsgBox.
I have tried a bunch of different methods, but I have the same problem with each one: the MsgBox is called after every instance of the value from range F2:F11 not existing in MainTable; i.e. it checks the cells one by one and calls the MsgBox each time the value is not present.
I would like the code to run through the entire table and then, at the end, call the MsgBox if the name from range F2:F11 was not found.
Said another way: Run through MainTable and check for the name "Bryan". If present, do nothing and move on to "Darrel". If not, call MsgBox. And do that for each name in range F2:F11forum.ozgrid.com/index.php?attachment/72780/