I have been asked to extract data from a website from a drop down list (for another online store so they can see each week the prices if they have changed -gone up or down for competitive rates).
The website to extract the data is here.
What I would like to do is extract the full result list from when you have clicked on the 'size' option, to show all of the prices and put the all of data into excel, e.g. into a column, instead of manually checking each one on the website.
Is there a way I can do this?
I normally just work the html side of things and am not sure how to complete this task.
Thanks guys if you can help me out with this, would really appreciate it.