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.
Now I need to manually add rows to table2 until alle accounts are listed, whcih is cumbersome.Please Login or Register to view this content.
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:
When this code works, I will:Please Login or Register to view this content.
- Rewrite the function to only retrieve accounts by the choosen owner
- Only count rows with a specific owner in the code
Bookmarks