Skip to main content

my workflow is like this

I used a loop that will take a table from each page of the web,

the table from the web contains 3 columns - Name Size Price

and after I changed each variable (by split, and more) I want to write them into a new Excel file.

and after that I will take the next page

You can use paste to excel command and use paste a table functionality of it to paste multiple rows.

Reply