Using web query to download data from multiple urls.
I have a problem I have been working on for a while now and cannot seem to solve it due to being a beginner with VBA. I have list of of postcodes in a spread sheet that I would like to search for the local diesel price on www.petrolprices.com. I have noticed that when I get the data it appears as one single table of data for the whole page this is not a problem as long as i can put in corresponding columns on Worksheet 2, Ideally though I would like to just get the lowest price for diesel for each each corresponding postcode. How can i do this over 500 postcodes. Any help would be very much appreciated if you have any further questions with regard to what I am trying to do I will respond quickly. Thankyou in advance.
Users Browsing this Thread
There are currently 1 users browsing this thread. (0 members and 1 guests)
Search Engine Friendly URLs by vBSEO 3.6.0 RC 1