Extract data from website to excel?
It's 3rd week that I am trying to extract some data from website to excel :
Some lists of data are split into multiple pages. Example: 100000 entries are displayed on 1000 pages, 100 per page. I want to extract the data WITHOUT having click the Next button and manually saving each set of data.How to create formulas to extract data from a website and input into an Excel 2010 worksheet?
website has some repeated part