Excel 2010: finding duplicates in child sheets and highlighting them in master sheet
Posted on 2014-07-16
I have an excel 2010 workbook (FMG All Good Emails_250K_Apportioned _MB-July16-14.xlsm) comprised of tens of thousands of records and about 20 sheets.
On the master sheet (FMG All Good Emails_July_Apport) there are approx 200,000 records (rows). All the other sheets are approximately 10,000 each and each one of them contain copies of records from the master sheet.
I need a function that highlights the entire row in the master sheet when the email address from that master sheet is found in one of the 'children sheets' (sheets other than the master) and I need the name of the tab inserted in every row in Col O of the master sheet.
For example. I have a sheet named Trevor Turner. The function would find all email addresses in sheet Trevor Turner and locate them in the master sheet (FMG All Good Emails_July_Apport). When a match is found in the master sheet the function would highlight the entire row with a unique color AND put the name Trevor Turner in every row in Col O.
I have the following children sheet:
Scott E. Naughton
Having this would be a great, great help to find who has what in the master list.
If there are duplications (an email found in more than one child list) then that would
be good to note somewhere as well if no match can be found.