Sort column in Numbers on data change

Hello Piotr,

Thanks for reaching out to us in Apple Support Communities about sorting in Numbers. We're happy to help by looking into this more! 

This can be done manually, but not automatically. Here's a resource that can help: Alphabetize or sort table data in Numbers on Mac - Apple Support

1. Click anywhere in the table, then move the pointer over the letter above the column by which you want to sort.

2. Click the arrow that appears next to the column letter, then choose a sorting option:

• Sort Ascending: Sort the data in alphabetical order (A to Z) or by increasing numerical values.

• Sort Descending: Sort the data in reverse–alphabetical order (Z to A) or by decreasing numerical values.

Note: If your data is categorized, it’s sorted within the category groups. To sort the groups themselves, move the pointer over the column with the group names and click the arrow that appears. Move the pointer over Sort Groups, then choose an option. To sort groups by summary row values, you can also click the arrow next to the column letter, move the pointer over Sort Summaries, then choose an option.

Hope this helps.

Best Regards.

The second table is full of formulas that pull data from the first table? If so, a change to the formulas might do it. it is hard to tell without seeing more and knowing the formulas you are using. A screenshot or two and the formulas might help.