Match Emails to URLs

Sharid

Well-known Member
Joined
Apr 22, 2007
Messages
517
I have a list of emails, I need to link them to the correct URLs. Problem is there are too many to do manual.

I was hoping for some vba code that would MATCH part of the string in the EMAIL to that of the URL and place it in the next column/s

Example
Sheet1 column A has all the urls

URLs
http://www.Whatcar.co.uk
http://www.Autotrader.co.uk
http://www.CarGURU.co.uk
http://www.Automart.co.uk
http://www.MotorWorld.co.uk

<tbody>
</tbody>


Sheet2 Column A has all the Emails

Emails
JohnDoe@whatcar.co.uk
JoeBlogs@MotorMadness.co.uk
JaneBlogs@MotorMadness.co.uk
JaneBlogs@MotorWorld.co.uk
JaneDoe@Whatcar.com
Info@Autotrader.co.uk
JaneDoe@BillysCars.co.uk
Contact@CarGuru.co.uk
Bill@MedicalGuru.co.uk
Jane@LifeStyleGuru.co.uk
Info@Martfury.co.uk
Info@AutoMart.co.uk

<tbody>
</tbody>
When the code is run it will link the Emails from Sheet2 to that of the URLs on Sheet 1. I understand that this may not work 100% correct,however it will link the bulk of the emails.

Some emails may have a simmilar string to that of the url, the second email goes into the next column, I can then look at these few individually.

So it will look like this when the codes is run


URLS
http://www.Whatcar.co.uk
JohnDoe@whatcar.co.ukJaneDoe@Whatcar.com
http://www.Autotrader.co.uk
Info@Autotrader.co.uk
http://www.CarGURU.co.uk
Contact@CarGuru.co.ukBill@MedicalGuru.co.ukJane@LifeStyleGuru.co.uk
http://www.Automart.co.uk
Info@AutoMart.co.ukInfo@Martfury.co.uk
http://www.MotorWorld.co.uk
JaneBlogs@MotorWorld.co.ukJaneBlogs@MotorMadness.co.ukJoeBlogs@MotorMadness.co.uk

<tbody>
</tbody>

IF POSSIBLE, the closest email MATCH to the url needs to go into column B Sheet1,

Any UNMATCHED EMAILS in Sheet2 are then highlighted in RED. This is because although I might have the URLs some emails are either Gmail, Yahoo, Hotmail etc. I can then look at these one at a time

Thanks
 

Sharid

Well-known Member
Joined
Apr 22, 2007
Messages
517
Hi

Can anybody help on this, I am really stuck

Thanks
 

Forum statistics

Threads
1,081,991
Messages
5,362,595
Members
400,683
Latest member
LogChief

Some videos you may like

This Week's Hot Topics

  • populate from drop list with multiple tables
    Hi All, i have a drop list that displays data, what i want is when i select one of those from the list to populate text from different tables on...
  • Find list of words from sheet2 in sheet1 before a comma and extract text vba
    Hi Friends, Trying to find the solution on my task. But did not find suitable one to the need. Here is my query and sample file with details...
  • Dynamic Formula entry - VBA code sought
    Hello, really hope one of you experts can help with this - i've spent hours on this and getting no-where. .I have a set of data (more rows than...
  • Listbox Header
    Have a named range called "AccidentsHeader" Within my code I have: [CODE]Private Sub CommandButton1_Click() ListBox1.RowSource =...
  • Complex Heat Map using conditional formatting
    Good day excel world. I have a concern. Below link have a list of countries that carries each country unique data. [URL...
  • Conditional formatting
    Hi good morning, hope you can help me please, I have cells P4:P54 and if this cell is equal to 1 then i want row O to say "Fully Utilised" and to...
Top