I'm trying to extract data from a website. I have a table of data (customer sales) online that updates daily. I can import this into excel no problems but the issue I'm having is that one of the columns is actually a column of links. When I click each link it shows the product details, I need to extract this information into my excel sheet rather than clicking into each link and typing in the product manually as there are 3,000 sales.
Do I need to highlight the column of links using a data extraction program, identify the URL and then use this to access the text(data) that I need? What software could I use, preferably free or is there anyway to do this through excel web queries?