Hi,

I have salary data in say 3 cells that I name them
(Insert-Name-Define) say CEO_Salary, VP_Salary and Manager_Salary.

Now when I sort this data the names point to different salaries. My CEO
is getting a Managers salary after the sort :-)

The names are pointing to different Ranges they were not originally set
for.

Is this normal? Shouldn't the names move along with the data just like
the cells formatting etc.

Is there a way to have the names keep pointing to the Data(Range) they
were originally meant for?

Thank You.
Gap.