I’m trying to pull data from a web query but I cannot get it to work the way I want. Let me explain:
I got a website for example http://blablabla/index.pl which shows a form I can search by telephone number to get specific data. I also got a list of telephone number into a spreadsheet on a daily basis which I need to query into that website so I can pull the data from it and import it into a Excel spreadsheet as well. If I enter http://blablabla/index.pl?phone=5558881234 as the query it brings me something but I need to query a lot of numbers. Is there a way for the query to grab the phone number from cell A1, A2, A3, etc. till the end of the list? And if so, how can I do that?
Thanks!
