I have two tables in Excel 2010, the second table has the last column filled with cells that reference the last column cells from the first table:

For instance, the value of the first cell in the last column in the second table `= (=F4)`

, so it references `F4`

cell which exists in the first table, the value of the second cell down `= (=F14)`

, the third one `= (=F19)`

, and so on.

As a result, the last column in the second table will sort incorrectly (false result). Is there a solution to this problem ?

thank you in advance.

valuesto another column, and sort it – belisarius Jun 12 '11 at 7:54