Project Description:
I have a list of retailers (around 60), including department stores, discount stores, hypermarkets and wholesale stores. I also have a list of cities (around 50). I need to get a list of locations of all the stores for a particular retailer located within a particular city. For example, if I got to Macy's store locator website and input a city, I will get a list of Macy's stores inside or near that city. If I have 50 cities, I have to input 50 times for a single retailer. If I have 60 retailers, I have to repeat 50 times 60 times and copy and paste their locations in a spreadsheet. This is time consuming. So I wonder anyone could help programming this task. Thanks a lot!