Match URLs and copy and paste from one sheet to another

[Sharid]

Hi.

Hope some one can help, I have been stuck on this for a few days and cant seem to work it out. I have a large list of customers and email address which i need to match from one sheet to another.

On sheet 1 Column A, I have URLS and in column B I have email addresses to those URLs. Not all Url have emails

On sheet 2 Column A, I have URLS and in column B I have email addresses to those URLs. Not all Url have emails

I need a VBA code that will do the following

1. MATCH the urls from sheet 2 to sheet 1 and copy any emails from sheet 2 to column B in sheet1 were there is no email.
2. If there is already an email in Sheet 1 Column B for THAT URL, then it pastes the new email into column c right row to url.
3. Any urls on SHEET 2 with or without emails are copied from sheet2 to the last url of Sheet1

 

[Fluff]

Glad we could help & thanks for the feedback