Can someone assist in providing a macro that does the following:
Compares data in sheet 1, starting at column B3, against column B in sheet 2. If there is no match, the row is highlighted red. For example, column B contains last names. When the macro is ran and the name Smith is not found in sheet 2, column B, that row is highlighted.
Microsoft OfficeMicrosoft ExcelVisual Basic Classic