Excel Macro function to run on a website to collect data
- or -
Post a project like this$$
- Posted:
- Proposals: 5
- Remote
- #2167186
- Expired
Description
Experience Level: Intermediate
I am requiring an excel function / Macro to run web addresses through a website and then grab and download information based on the result.
For example: The website we use is
https://www.truecaller.com
This website is used to search the true identity of mobile numbers, however, as I am working in sales, we need to reverse the function, so for example we need an automated macro to run a vast amount of numbers as the search bar function looks like the following:
https://www.truecaller.com/search/qa/55445211
This brings up the name Kamal Katar. So what the macro would do would paste the number to a spreadsheet, and then the Name next to it.
Then it would search the next number sequence for example:
https://www.truecaller.com/search/qa/55445212
https://www.truecaller.com/search/qa/55445213
https://www.truecaller.com/search/qa/55445214
https://www.truecaller.com/search/qa/55445215
Etc etc...
Does that make sense?
Sorry I am not very technical when it comes to excel!
Thanks
Craig
For example: The website we use is
https://www.truecaller.com
This website is used to search the true identity of mobile numbers, however, as I am working in sales, we need to reverse the function, so for example we need an automated macro to run a vast amount of numbers as the search bar function looks like the following:
https://www.truecaller.com/search/qa/55445211
This brings up the name Kamal Katar. So what the macro would do would paste the number to a spreadsheet, and then the Name next to it.
Then it would search the next number sequence for example:
https://www.truecaller.com/search/qa/55445212
https://www.truecaller.com/search/qa/55445213
https://www.truecaller.com/search/qa/55445214
https://www.truecaller.com/search/qa/55445215
Etc etc...
Does that make sense?
Sorry I am not very technical when it comes to excel!
Thanks
Craig
Craig L.
0% (0)Projects Completed
-
Freelancers worked with
-
Projects awarded
0%
Last project
4 May 2024
Qatar
New Proposal
Login to your account and send a proposal now to get this project.
Log inClarification Board Ask a Question
-
There are no clarification messages.
We collect cookies to enable the proper functioning and security of our website, and to enhance your experience. By clicking on 'Accept All Cookies', you consent to the use of these cookies. You can change your 'Cookies Settings' at any time. For more information, please read ourCookie Policy
Cookie Settings
Accept All Cookies