Names ranges within a table not correct after sort

[CeliaA]

How do I create names that will stick with my data even when I move it around?

I have my data in a table, to make it easier to sort. It looks likes this:
Project Value Timing Stage Confirmed(Y/N)
Proj1 $100 3/15/11 Confirmed TRUE
Proj2 $50 4/1/11 In Contract FALSE
Proj3 $150 4/1/11 Confirmed TRUE

I used the "name from selection option" to create names for both the columns and the rows, which worked beautifully and let me create references on other worsheets based on the intersection (ex. =Proj1 Timing). Then I sorted based on "stage", at which point the name "Proj2" referred to the data that is in row 3 in my example above. I know this is because the names are absolute references, but when I tried to change them to relative ones using the name manager, the ranges were different every time I looked.

Help!? Is there a way to use named ranges that allows for repeated sorting?

Thanks!

 

[GlennUK]

That's not the way defined names work. See here:
http://support.microsoft.com/kb/58245

You'll have to recreate the names after sorting, if you are going to be sorting your list.