I have the attached spreadsheet with two worksheets. One worksheet (called data) just lists rows of email addresses and the other worksheet (called emails) also lists email addresses. What I would like to be able to do is create a VBA macro which will look at the email addresses on the emails tab (this list will change regularly) and if the email address does not exist in a row on the data tab in either column Email 1 (F) or Email 2 (H) then delete the row - the effect being it will leave only rows where the email (from the emails tab) appears in either column F or H! If possible I don't want the check to be case sensitive - I was thinking of using something like UCASE in the macro or something?
Could someone help me with this macro - I have started but failed at getting it to work.