Looping through a row and copying each cell In a specific procedure

[jalix]

What I have to do is use Excel VBA to:

1) login to Amazon Seller
2) open a workbook
3) loop through a column to get an order number
4) put it in the search box
5) hit the search button
6) go to the order page and extract the data
7) then have the extracted data go back into a specified column in another Excel workbook

The loop and order number parts are what I'm currently stumped on. I've figured out this much code as of this moment:

Please Login or Register  to view this content.

This is a bit complicated, and I'm only a beginner in Excel macros. Any help would be greatly appreciated.