CHALLENGE! Issue sorting data containing relative references on a separate tab

[lax828]

Hello -

I have a challenge for some MVPs or Excel gurus out there (who knows -- maybe this is easy...).

I have an example sheet (which you can download below). The problem involves sorting table data on tab 2.

http://dl.dropbox.com/u/2625864/Foru...ampleData.xlsx

On tab 1 (Data), there are two columns (Name and Completed?). There is also a table where sorting works fine. When I sort any of the columns, the data moves with the appropriate rows as expected.

On tab 2 (Data2), the same table from tab 1 is there, in addition to another sammple table.

When I sort items in either of the two tables, the rows within each of the tables DO NOT move appropriately. For example, if I sort the names, the names sort fine but the data in the other columns does not move. If I sort the columns with the numbers, the numbers don't even sort correctly (an ascending sort sorts the data in a very random order).

I'm decent at Excel (or so I thought) but this has got me baffled.

Any help would be great!!!

[shg]

Duplicate post, thread closed.

Please take a few minutes to read the forum rules.

Thanks.