Looping help needed.

[vibajajo64]

I have a list of 400 stock symbols in cell A1 of an excel spreadsheet. I then go to a macro and load this website:

https://finviz.com/quote.ashx?t=" & Range("A1").Value

The macro, parsehtml below pulls data into excel from 400 snapshot stock tables. The results load starting in row 1-400 of the spreadsheet.

The problem is that 400 is the limit of snapshot stock tables you can bring in on 1 page and I have many more.

Therefore, I have to have a second page

https://finviz.com/quote.ashx?t=" & Range("A2").Value

I want the results from page 2 to load in row 401 to 800, however they are overwriting the data in row 1-400.

Does anyone know how make the results from page 2 continue starting in row 401?

For testing purposes, I've attached a file with only 7 items in Cell A1 and 7 items in Cell A2. Thanks for the help.

Please Login or Register  to view this content.

[Dal123]

Hiya, sorry I don't have time to look at it properly but it sounds like you're not resetting the upper and lower limit of the range you're working with. You're working with rows 1 - 400 first, then you're not assigning a value of 401 - 800.

Sorry I know that's not much help.

Please Login or Register  to view this content.

There's probably something I'm overlooking but hopefully this at least gets you on to a research pathway to success.

[vibajajo64]

Hi, no that doesn't work. It just starts everything in row 401-800 and then overwrites the next 400 in the same 401-800 area. Thanks though

[Dal123]

Thanks, sorry about that, just to state the obvious, you're putting it in the second loop right?

Please Login or Register  to view this content.

[vibajajo64]

Yes, I don't know how to get it put the first 400 lines in Cells 1 to 400 and then the next 400 lines in Cells 401-800. Actually, there will even be more going all the way to 4,000 lines.

Thanks

[Dal123]

I'll try to have a look at this tonight, so that particular block of code with 2 loops is the overall process.

Sounds like you need a parent object loop, which would loop dynamically for each table in the workbook. Are all these tables conglomerated into the same workbook?

It looks like you're parsing them into the workbook from a webpage?

Sorry I know I'm not giving this proper attention.

[vibajajo64]

Yes, the data is coming in from 2 pages from a web site. I want the results all on one 1 excel spreadsheet from lines 1 through 800. So currently, the first 400 come in from page 1 of the website like I want but the next 400 from page 2 of the website overwrite the first 400 instead
of continuing on line 401 through 800.

Thanks,

Vince