Populate and rezise table2 as table1 changes

Structure:
I have two tables, table1, "Kontoinformasjon" in sheet1 and table2, "Utestående_Betaling" in sheet2.
Table1 contains a list of acount numbers in one column and the owner of that account number in a second column. This list is not fixed in
Sheet1 in which the table2 is located also has a cell with a drop down list of owners.

Functions:
Table2 should be populated with account numbers of the choosen owner, and rezise it self accordingly.

So far:
I am using a function to populate table1 from table2. This list all the account regardless of the owner.

Please Login or Register  to view this content.

Now I need to manually add rows to table2 until alle accounts are listed, whcih is cumbersome.

I would like to rezise the table2 to match the number of rows needed, but so far I am stuck on retrieving the numbers of rows from table1, as the code throws an Index Out of Bounds error. This is the code:

Please Login or Register  to view this content.

When this code works, I will:

1. Rewrite the function to only retrieve accounts by the choosen owner
2. Only count rows with a specific owner in the code