HElp scraping data and adding to list table as column

[Jpizzo 0]

Ok this time I am trying to add list data by scraping it from yellowpages.com. 

 

I do all the usual stuff to navigate and search my terms then I scrape the data and here is where the problem comes. I run the add list to table as column inside of a loop I set my row and set my column both to 0 then scrape the data finally navigate to the next page. The scraped data gets written over because I'm guessing the row goes back to 0. How do I fix this and if on page 1 it scrapes 20 addresses and phone numbers then page 2 it will continue to the list and not rewrite my first 20 rows?

 

Thanks I love you guys for helping me!!!!!

[north_star 16]

you have any code sample..? or you cab try to set " Dont delete Duplicate" on your "add to list" comand

[Jpizzo 0]

I will provide a sample this evening but Im trying to get my computer back up after the new update...

[VaultBoss 310]

Loop through all the pages and continue to add list to list till you finish scraping.

 

Only AFTER that, add the list to a table if you wish so.

 

The way you're doing it, will, indeed, overwrite the list collected from the previous page.