Pull data from webpage

[ssuman1010]

Hello All,

I need a program which can pull data from a particular website after inputting certain data.


The webpage address is : " xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx"

there are three tabs on the page.

First tab is location :

second tab has three dropdowns - boys, girls, and boys & girls

thrid tab is view report.




I have a list of locations eg. a, b, c, d, e, f, g, etc

need a macro which shall put one location on the first tab and select boys & girls and then slect view report and then extract that report in excel format.
and then continue to the second location and perform this operation.


Thanks a lot for the help in advance