Designing a function/macro that compares 2 columns and highlights rows that are missing

Hi Everyone,

Here's my situation, I'll try to be as clear as possible. I have two tables of data in my workbook on separate sheets. The first sheet, "Accounts Master" is a master list that is updated monthly. The second sheet "Current Accounts" contains the same info (in a different order), but it is added to as accounts are added into the system. Both lists will be expanding in quantity as the months go by, in case that's relevant.

Here are the two sheets side by side for reference.

Excel Help.jpg

Ideally, what I'd like to do is have the master list "consult" the current list and see if there are any accounts on the master list that are not on the current list. If the account is missing, I would like to highlight that row in a yellow color on the master list.

Incase it's not clear from the picture, the account #'s begin at E11 on the "Current Accounts" sheet and on the "Accounts Master" sheet the #'s begin at B10

I have tried to adapt some similar macros from the board to fits my needs but I have been having a lot of trouble because I am very inexperienced with macros.

I would really appreciate any help you guys could offer. It would make my job 1000x easier!

Thank you

Hi and welcome to the forum

Did you take a look at that jpg you uploaded??

Please do not upload a picture of your file...rather, upload a sample of your workbook, showing what data you are working with, a few samples of your expected outcome is (manually entered is ok) and how you arrived at that. (exclude sensitive info). Pictures are pretty much impossible to edit, and no-one wants to re-type your data for you Also, not all members can upload picture files (Company firewalls and stuff)

Cross posted
http://www.mrexcel.com/forum/excel-q...s-missing.html