VBA scrape data from website HTML

Hi,

I made a VBA code that scrapes the morningstar dates of some mutual fund quotes, and places them in a column, right to the fund id.
Nevertheless, I have been trying to code the exact same operation, but instead of placing fund ID on a column, place it on a line, and expect excel to scrape the dates on the line below, just like indicated:

screenshot.PNG


Could you be so kind as to show me how can I fix my code to do so?

.xls file:

https://we.tl/BMFb7jDGAc


VBA code:

Please Login or Register  to view this content.

Thanks so much!

This will transpose the data in rows below.
Add the bolded lines of code at the bottom of your macro.

Please Login or Register  to view this content.

May be

Please Login or Register  to view this content.

Change the range to suit.

Please Login or Register  to view this content.

You're welcome.Glad I can offer some help
As for Mr. AlphaFrog's post #5, I think it is working well too (Have it a test)

You're welcome. Please mark the thread as solved