Brief description of what i want my macros to achieve: I've trying to import data from two Excel spreadsheets, and then compare the data on each list to find the missing elements in each list and then highlight the data row if it is missing. Still rather new in excel-VBA please go easy on me..
Kinda puzzled with the error i have here for my excel-vba codes while running the code below. Below i have attached a copy of my Excel file for you reference. Thanks for your help and time in advance.