could you give me a hint how to link one table to the other table so that the second table is an aggregated version of the first table (e.g. filtered In Scope) and the second table is followed by additional columns. The second table should also be actualized in the case, if I insert a new row in the first table and filter it as "in Scope".
Table1
Table2
I hope I could explain it to you and thank you in advance.
Best regards, Mo
I've tried it to connect via PowerQuery but the problem is, if I actualize my query the additional added rows are moving an they dont have match to the right row.
I also created two tables but if i use Vlookup i got #SPILL!
I also tried to connect it via the formula Filter but in this case i get the right rows but cannot sort it.