Hi there,
I have a list of website URLs in one column lets say A1 to A704
In this format:
www.website.com/page=1
www.website.com/page=2
www.website.com/page=3
www.website.com/page=4
etc.....to page 704
I want the excel web query command to extract and import the text from each page and then paste it in ONE new sheet in one column, with each page after one another so....
Page 1 Text extract
Page 2 Text extract
Page 3 Text extract
etc
How would I do this?
Bookmarks