VBA to import multiple xml data into same workbook sheet

[capnhud]

I currently have a macro based on a previous question I asked Retrieving XML Data by looping through a column range

Please Login or Register  to view this content.

that can import xml data from a column range url and place the data in a row on the same sheet of the workbook (combinedDataURL sheet).

But my problem is how to convert the macro to handle xml data that fills up more than one row so that each subsequent import is one row below the previous table (which may be longer or shorter than the previous table) and the header row of each table is hidden.

The recorded macro looks like this:

Please Login or Register  to view this content.

how can I get this macro to do the same as the first? Any assistance would be appreciated