I am looking for some help with a macro that will do the following, however I am not sure where to start with this as it was not as straight forward as I had thought.
I have the attached worksheet - it has two tabs one called data (with two columns of email addresses on) and another called emails which has a list of email addresses and notes associated with the email address.
I am looking for the marco to:
If any email address in column 'f' or 'h' on the data tab matches an email address listed in column 'a' on the emails tab then where the match was found it should copy the note in column B of the email address matched from the emails tab to column 'z' on the data tab on the row where the match was found.
The bit which I really was not sure about was where two email addresses in column 'f' and 'h' on the data tab on the same row matched two email addresses in column A on the emails tab - which note from column 'b' would it copy to column 'z'? In this instance I would like the note from the email matched in column 'h' to be copied! I am not sure how to handle this either.
Any help would be appreciated.