Sharid
Well-known Member
- Joined
- Apr 22, 2007
- Messages
- 1,066
- Office Version
- 2016
- Platform
- Windows
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
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
- 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.
- 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.
- Any urls on SHEET 2 with or without emails are copied from sheet2 to the last url of Sheet1