Hi, i have excel sheet with two sheets to loop through(Category and Province), i loop through the 1ts sheet(Category) and within that category i need to detemine the province from the second sheet, so i loop through the the Province sheet as well, both loops i am using For Each Row.
I am using those sheets to manipulate a certain website, so 1st the catergory will be selected in the drop down, then the province, after the province the button search will be pressed.
after the button search is being pressed and the results returned, i need to scrape those results and save them in the respective province, that is where i am having a problem. below is the website i am working on