Basically, I have a list of people and I need an automated process to find their location. I have an Access Database (that can be easily converted to Excel) which has tens of thousands of contacts., all of whom I know have LinkedIn Profiles. Most of these contacts have the person's city, but about 30,000 do not. I need a process to automatically fill in these missing locations. I have quite a bit of data on each person including First, Last, Title and company.
I need a formula, macro or Power Query or Microsoft Power BI to search the person's first and last name and either title or company in order to make sure it's the right person on Google (or another search engine), and return the city in the database. For instance, if Power Query searched their first, last and title and "linkedin", the first result should be their linkedin profile, and their location will be listed in that search result. I need it to scrape this location data and return it to the sheet.
I need this to be:
1. Powerful enough to go through tens of thousands of entries and not get flagged by Google (or however it searches the web) as a bot
2. Repeatable on any similar list in the future
I'm not sure if this is possible to do this or not, so please do not accept this job if you don't already know how to do this. I don't want to waste anyone's time!
Looking to make some money?
- Set your budget and the time frame
- Outline your proposal
- Get paid for your work
Bids on this Project
Working as a VBA programmer (Excel & others) ever-since completing a masters degree from Victoria University, Melbourne, Australia. I used to work as an assistant programmer during high-school years where I developed software with VB that manipulated data from SQL Servers. From 2012 and onwards I am working with VBA. VBA is just like VB, but focuses mainly on MSOffice applications like Excel, Word, Access etc. For you I can develop nicely written efficient programs that use and manipulate data from Excel / Access / Word. Since I have a good deal of experience in this language you can be sure I’ll write the most efficient one and in the least amount of time. You’ll be able to automate ANY tasks in excel you desire. Do you need to automate Web tasks too? I use Selenium with Python or VBA to mimic user activities on websites and scrape desired/complex data that are not easily accessible by normal scrapers. I’ll write you the script that WORKS. Just knock me for a discussion. Thank you.
I'm working in one of the biggest companies in the world as Reporting Specialist. Most of my day is filled with Excel tables and pivots. I know VBA language so I'm able to prepare the best macro you need!
Moscow, Russian Federation
Since 2014, we have been realizing all of the clients ideas which are aimed at establishing and improving all of the business processes. In our work we rely on our technical vision which is based on practical experience received over the years of hard work. Some facts: Our freindly team consists of more than 100 employess More than 70 implemented projects We are trusted by clients from at least 5 countries
With more than tow years experience as Advanced Financial Excel instructor, and advanced knowledge in building Access database including quires, forms and reports, I can build solutions for everything (like dadtabase for your clints or students or anything related to your business as Accounting program etc,). I recently move to Germany to learn german language and get a master degree.
Divulge Technologies offers the most tangible and finest e-commerce solutions. -E-tailing or "virtual storefronts" on Web sites with online catalogs, sometimes gathered into a "virtual mall". -The gathering and use of demographic data through Web contacts. -Electronic Data Interchange (EDI), the business-to-business exchange of data. -E-mail and fax and their use as media for reaching prospects and established customers (for example, with newsletters) Business-to-business buying and selling. -The security of business transactions. When it comes to Wordpress, Divulge Technologies knows that there is no spoon! Services Offered: -Wordpress as a CMS. -Wordpress Theme Development -Plugin Development -BBPress Customization & Integration -Wordpress: Social Networking -Wordpress: E-Commerce Outsourcing your IT can provide your business with: -Guaranteed service delivery with enhanced Service Level Agreements. -Provision of a stable and secure IT infrastructure with 24 x 7 x 365 support. -Access to a highly skilled technical resource that most businesses simply could not afford to employ -More ...
RoyalCalif Techonologies is a registered firm based in India Offering a wide range of back office and Information Technology Enabled Services namely Data Entry Offline Data Entry Form Filling Data Entry using the given package Rapid and accurate keying from images of structured documents Online Data Entry Email Handling Semi Automated Data Conversion Data Entry in Shopping Cart and Maintenance Video uploading Graphic Design o Logo Design, Icons, etc., o Layout for websites o Picture Editing etc., Web Development o Website Designing (layouts, static pages, CSS) o Website Applications (Dynamic pages, Registration form, shopping cart, User control panel to maintain website content, etc.,) o Website Maintenance (bug free, email assistance, etc.,) Search Engine Optimization Web Promotions
Business data modeling, data analysis, Excel VBA. Application development. Simplified Chinese, Traditional Chinese, Cantonese
NEW DELHI, India
MIS Officer with cross functional expertise in Industry and Data analyst. More than 6 years of experience in the industry such as Consumer Durables, Automobile and Footwear combining strong analytical skills with business wisdom to positively contribute to organization’s bottom-line. Well versed with MS-Office Tools (Word, Excel, PPT, and Access) and SAP. Proven history of improving operations and increasing profitability. Ability to talk and conduct Services. XP/WISTA/WINDOW-7/WINDOW-8. MS-ACCESS, SQL SERVER-2000, 2005, 2008-R2. TALLY-9 & SAP. Knowledge of C++, Visual Basic-6.0. Knowledge of Photoshop CS2.