Hi, I have one sheet with 2125 URLs such as:
http://www.crunchbase.com/funding-rounds?page=1
http://www.crunchbase.com/funding-rounds?page=2
this goes on till 2125, last URL being http://www.crunchbase.com/funding-rounds?page=2125
I want to scrap every page on another sheet (ONE SINGLE SHEET). One after the other page on the same sheet, so that when I sort at the end, I get all of the tables arranged (from each page) one after the other. Every URL results in approx 125 rows of data.
I am not being able to change destination range. Please help...
http://www.crunchbase.com/funding-rounds?page=1
http://www.crunchbase.com/funding-rounds?page=2
this goes on till 2125, last URL being http://www.crunchbase.com/funding-rounds?page=2125
I want to scrap every page on another sheet (ONE SINGLE SHEET). One after the other page on the same sheet, so that when I sort at the end, I get all of the tables arranged (from each page) one after the other. Every URL results in approx 125 rows of data.
I am not being able to change destination range. Please help...