How do I sort a table that is referenced by another table?
<p>I have this table that is made from reference to other table.</p>

<p><a href="https://i.stack.imgur.com/8QNWq.jpg" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/8QNWq.jpg" alt="table"></a></p>

<p>and now I want to sort from small to largest the third column, but since it is referenced from another table is not sorting. And I also dont want excel to sort the reference table and I need the table to be referenced because I will change some values on the reference table and I need them to be connected, so I just cant copy and paste the values and then sort.</p>

<p>Could you give me some help?</p>