How to automatically expand table 2 with data from table 1?

Hello  Lorenzo ,

Happy New Year, by the way 🙂

Thank you for your reply.

I don't know what a dynamic array would do, but i wouldn't want to loose the capabilities that a table provides.

So I'm going to try asking help with VBA.

By the way, another issue i have, if you don't mind, is not being able to use Custom Sort in a table on columns that have formulas.

Excel sorts with one column but more than that, when it starts i can see the sorting happening but when it finishes it goes back to how it was before the sorting was applied. Which forced me to paste only values of that table on another table and then do the sorting.

Is this normal, or do i need to enable/disable some option somewhere?

I appreciate your help. Thank you.