I have to collect the search result data(all pages) of the following website
http://www.autotrader.co.uk/search/u...us/1500/page/1
there are around 11150 dealer data
i have to copy the data of dealer from all pages and paste it in to excel sheet
i have copied some of pages but it is tedious process to do manual
please help me out by taking all the data automatically using Macro/VBA Code....
i had also saved all the search pages using software " Website Ripper Copier"
i have attached one example of required data in excel and selection of website data in screenshot....
Bookmarks