I have a certain contacts data ( company name, address, phone and email) that is displayed on search request in tables on consecutive pages of a website.
The URL is identical for each page with only " page=1" part of the URL changing on each next page.
Also the website is password protected. I can create refreshable web queries on excel , by logging into the website through excel, but to do that have to individually open and pull each page separately.
Is there an easier way to automate the data to be pulled from all pages, given the no of pages the data spans is known.
Bookmarks