Create datatable 2 tables in 1 sheet

Hi Guys,

I am struggeling with the following problem:

I have 1 excel sheet which contains two tables. Both tables have headers and are seperated by 2 blank rows. These blank rows however, differ for each excel file. What i would like to do is read the top and bottom table and extract data from a website and fill it in in the table (by using for each loop).

I assume i have to create two seperate datatables in order to do this as the current read range procudes an error whenever it reaches the blank rows.

Does anyone have any idea how to do this?

Thank you in advance!


Can you try with range ?