I have several worksheets that are in one workbook. One of the worksheets is
updated daily (We will enter in our foremen's initials if they are working).
I want Microsoft Excel to recognize when one of our foremen is not working.
I have created a list of the foremens names and the initials that are used.
I want Excel to see if the initials are in Column D. If they are NOT, I want
them to drop the initials AND name into column M. This is an effort to have
our information more readily available and accurate. Any help, would be
AWESOME!

I could send the file so that you know exactly what I mean...