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.

Skills: App Designer, Excel, Software Architecture, Software Development, Web Scraping

See more: 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

About the Employer:
( 3 reviews ) Poblacion Makati, Philippines

Project ID: #11571547

Awarded to:


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 More

₱9000 PHP in 6 days
(135 Reviews)

33 freelancers are bidding on average ₱10868 for this job

₱7058 PHP in 3 days
(254 Reviews)

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

₱6588 PHP in 3 days
(124 Reviews)
₱20000 PHP in 7 days
(236 Reviews)

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 More

₱25000 PHP in 10 days
(118 Reviews)
₱10588 PHP in 3 days
(274 Reviews)

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 More

₱26947 PHP in 45 days
(22 Reviews)

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 in 10 days
(298 Reviews)

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 More

₱10000 PHP in 5 days
(144 Reviews)

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 More

₱16666 PHP in 3 days
(152 Reviews)

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 More

₱10000 PHP in 4 days
(147 Reviews)
₱10000 PHP in 7 days
(51 Reviews)

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 More

₱11111 PHP in 3 days
(46 Reviews)

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 in 5 days
(98 Reviews)

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

₱5998 PHP in 4 days
(168 Reviews)

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 More

₱5882 PHP in 3 days
(71 Reviews)

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 in 3 days
(76 Reviews)

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 More

₱9411 PHP in 3 days
(65 Reviews)

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 More

₱5200 PHP in 3 days
(50 Reviews)

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 More

₱10000 PHP in 2 days
(12 Reviews)

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 in 7 days
(53 Reviews)