This is a very simple project.
I need this done quickly after being hired.
Ignore the $999 budget and bid what you believe is fair.
Open the attached workbook.
This is a simple Excel-based CRM.
New leads are loaded in the “new” tab.
The current database of leads is in the “main” tab.
The user will place new leads in the “new” tab and we need a script/macro that will move the new leads from the “new” tab into the “main” tab.
However, we do NOT want duplicates added.
Your script will clean up all the URLs (column A) from the “new” tab and remove the “www.” so we are left with the rest of the domain name (e.g.: “www.yahoo.com” will be converted to “yahoo.com”).
Next your script will compare the URLs against the company names (column A) in the “main” tab.
If there are duplicates these rows will be ignored.
The remainder URLs will be appended to the “main” tab
In the workbook, the “new” tab has two duplicate records (fenixlighting.com and brightguy.com).
Thus the remaining records in the “new” tab (the URL and the phone number) are appended to the “main” tab.
After the append is done, the “new” tab is cleared out (from row 2 and down).