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

Completed

Description

Current process

1.

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.

2.

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.

3.

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 data24-7.com. 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

Project ID: #11571547

Awarded to:

aarifakhtar

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)
6.7

33 freelancers are bidding on average ₱10868 for this job

₱7058 PHP in 3 days
(254 Reviews)
7.6
₱20000 PHP in 7 days
(236 Reviews)
7.1
srinichal

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

₱6588 PHP in 3 days
(124 Reviews)
7.3
esalem

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)
6.8
AishaAlimuhammad

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)
6.9
bob1982

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)
6.8
koolsidz

Hello :) My Credentials: 20+ of Excel/VBA Experience. http://www.siddharthrout.com/aboutme/ 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)
6.5
elqueabandona

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)
6.5
₱10588 PHP in 3 days
(274 Reviews)
6.7
mwarrenschultz

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)
6.2
₱10000 PHP in 7 days
(51 Reviews)
6.2
dpune

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)
6.3
redouaneaberdin

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)
5.8
expertatwork

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

₱5998 PHP in 4 days
(168 Reviews)
6.0
katilinas

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)
5.6
rohitpithisaria

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)
5.6
jayamsoft

Hi, I will develop the MS Excel Ribbon / Tool Bar for your need all the operation will perform through on single click for each of your requirements. We are experienced programmer with more than 5 years of develo More

₱25882 PHP in 20 days
(14 Reviews)
5.5
TonmoyRoy111

Dear client, I have sound knowledge in Excel and I have previously carried out a number of projects in excel using macros and formulas. I ensure you will be happy after hiring me. Kindly contact me for further detail More

₱10000 PHP in 5 days
(129 Reviews)
5.6
vlayausa

Hello, I am proficient with Excel and VBA and I would love to help you make this macro you need. Please contact me for more info.

₱4200 PHP in 2 days
(81 Reviews)
5.2
ReflexiveData

Hi, Thanks for posting this project.Please check our website: www.reflexivedata.com & 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)
5.1