Write some Software for Excel automated vlookup, sorting, and advanced finding

Current process


I have a list of business addresses that can get service from a cable provider. On almost a daily basis I have someone go to a website do a lookup for the zip codes that contain the businesses on the list and manually download 250 at a time, until he produces a list of 6000 business names on an excel spreadsheet.


He then does 4 vlookups and creates 4 new columns, 1) Addresses that can get charter coax cable internet, 2) addresses that can get charter fiber internet service, 3) Companies that I know we can’t sell to for example Walmart, Target, and Google, 4) Industries that are difficult to sell to, 5) Companies with certain websites.


He then forwards me the spreadsheet, and I do further sorting which is hard to teach to him. I separate any businesses with 25 or more employees because these are hard to sell to. I also, seperate businesses based on industry description and employee size that are better to sell fiber to rather than coax.

3. I then take out duplicate phone numbers and copy and paste all numbers to a different spreadsheet in one column. I take this spreadsheet and upload to a website called This website then tells me what the current phone provider is for the company phone numbers.

4. I then take these phone numbers and carrier names add them to the spreadsheet that was downloaded using another vlookup (matching the carrier names to the phone numbers on the spreadsheet. I then give this spreadsheet to my IT person who uploads it into my dialer.

I would like for you to create a software that helps with these processes and does a couple more things. This is what I was thinking.

1. I provide you the spreadsheet with companies and lots of data that we manually download

2. Your tool does the following vlookups. 1) Addresses that can get charter coax internet, 2) addresses that can get charter fiber internet service, 3) Companies that I know we can’t sell to for example Walmart, Target, and Google, 4) Industries that are difficult to sell to, 5) Companies with certain websites.

3. Your tool also does some sorting. 1) Finds companies that are good to sell fiber to based on serviceability, industry description, and size(which are columns on the spreadsheet). For example any imaging companies, hospitals, law firms, accounting firms over 8 employees, construction companies over 30 employees, architecture companies over 15 employees, churches over 20 employees, and other various rules I would give you.

4. There also would be a column that includes what phone provider the company is using. I would like the tool, also creates another column which shows the number of other businesses at the same business address and lists the names of the companies that are also using Charter based on the column with that data.

All in all this may sound complicated but it is actually quite simple. About 5 vlookups, a couple sorts based on some critera, and identifying companys in the same building using a simple excel formula.

Habilidades: Diseñador de aplicaciones, Excel, Arquitectura de software, Desarrollo de software, Extracción de datos web

Ver más: excel automated project visual basic mechanical engineering, excel file write mysql database jsp, excel vba write xml document file, excel macro write xml file, excel vba write xml file, scheduling software excel price, excel vba write csv cvs, sorting text files excel, develop mlm software excel, car park management software excel, java programs read excel sheets write mysql database, let customer write review product website software script, buenos aires software excel, excel automated graph, excel automated graphs

Información del empleador:
( 3 comentarios ) Poblacion Makati, Philippines

Nº del proyecto: #11571547

Adjudicado a:


Hi: I have a question: Do you want to automate the task that you do ONLY in Excel (sorting, filtering, etc.)? For instance, the lookup for zip codes and lookup for phone service provider on data24-7 . com can also be a Más

₱9000 PHP en 6 días
(135 comentarios)

33 freelancers están ofertando el promedio de ₱10868 para este trabajo

₱7058 PHP en 3 días
(254 comentarios)

Looking forward to discuss further details about the project and deliver the same to your requirements

₱6588 PHP en 3 días
(124 comentarios)
₱20000 PHP en 7 días
(236 comentarios)

Hello, We can get you this software on Google Docs. It will run as a normal software and you will get the desired data easily. I would like to see the file first which you get on Daily basis and if the formatting remai Más

₱25000 PHP en 10 días
(118 comentarios)
₱10588 PHP en 3 días
(274 comentarios)

Hello, I am VB, VBA, C#, WPF, Java, Delphi, PHP, ASP.NET, CAD and GIS developer, I developed many desktop applications and custom tools, macros and Add-Ins. For reference see my profile. I am ready to discuss and Más

₱26947 PHP en 45 días
(22 comentarios)

Hi, i am very good in excel vba/macro i have read the description and quite sure i am able to do the work with desired accuracy hope to hear from you soon

₱9411 PHP en 10 días
(298 comentarios)

Hi, I have more than 14 years of VBA/Excel exp and I am expert in this kind of work. Please send me more details about the work. It will help me estimate time and cost. I have completed more than 280 project Más

₱10000 PHP en 5 días
(144 comentarios)

Hello :) My Credentials: 20+ of Excel/VBA Experience. [login to view URL] I am an MS-Excel Expert besides being an MVP (Microsoft Valuable Professional). If you see my reviews by navigatin Más

₱16666 PHP en 3 días
(152 comentarios)

Hello, my name is Cristian, I have a degree in Business and work with excel every day. I have much experience with spreadsheets, formulas, models and macros. Check my reviews. They speak for themselves. Best rega Más

₱10000 PHP en 4 días
(147 comentarios)
₱10000 PHP en 7 días
(51 comentarios)

Hello! I am a professional programmer with many years of web scraping experience using Python. I have read your project description, and I can create the program you require. To do so, I will use the libraries Requests Más

₱11111 PHP en 3 días
(46 comentarios)

Hi there, My name is Redouane. I am very interested in your project. Kindly start messaging so we can discuss further details. Thank you

₱10000 PHP en 5 días
(98 comentarios)

hey there... I can get this automated for you. thank you...

₱5998 PHP en 4 días
(168 comentarios)

Hello I am an excel expert and would like to bid on the project posted by you. I have completed more than 100 projects in excel. FYI: Freelancers are not authorized to send any attachments to the employer before Más

₱5882 PHP en 3 días
(71 comentarios)

Hello. 35 % of employers hiring me once hired me again. I have experience in the same. I CAN do this job, and do it well!

₱11764 PHP en 3 días
(76 comentarios)

Dear Project Poster, I have relevant hands on 5 years of experience .We have a team of all the skills. I assure you about the work quality and time delivery. Please give me chance to complete this project. I Have Más

₱9411 PHP en 3 días
(65 comentarios)

Dear Sir/Madam, I have 3 years of experience in Excel VBA programming. I work as a business data analyst at Vodafone creating automated reconciliations and reports on our corporate customers. I think I could prov Más

₱5200 PHP en 3 días
(50 comentarios)

Hi, Thanks for posting this [login to view URL] check our website: [login to view URL] & reviews. For excel related projects please check the proposal. I have worked on integrating excel, word, SQL database, Power BI a Más

₱10000 PHP en 2 días
(12 comentarios)

Hello, I am Excel and VBA expert. Can I see sample xls data file? Please note that I have 100% completion rate and 5-star feedback on 50 projects.

₱6222 PHP en 7 días
(53 comentarios)