cell looses name after sorting

  • Thread starter Thread starter jimfx
  • Start date Start date
J

jimfx

Can someone help me with the following problem in Excel 2000:

in a table I have attached serveral cells with unique cell names, the
values in these cells are used in other sheets.

the problem is that when I sort the table, the cell names stay in the
original rowposition; they are not sorted! while their values are. So
Cell names get different values, and other calculations on my other
sheets get messed up!

How can I make the cell names relative instead of absolute?

thankx in advance,
Jim
 
jimfx > said:
Can someone help me with the following problem in Excel 2000:

in a table I have attached serveral cells with unique cell names, the
values in these cells are used in other sheets.

the problem is that when I sort the table, the cell names stay in the
original rowposition; they are not sorted! while their values are. So
Cell names get different values, and other calculations on my other
sheets get messed up!

How can I make the cell names relative instead of absolute?

thankx in advance,
Jim
Click to expand...

You should understand that sorting does not sort cells - it sorts data. The
cells remain fixed, whilst the data is moved into different cells to
accomplish the sort. Therefore, whether you reference cells with their cell
addresses or by name, after sorting the references will return different
data.

If that's not what you want, the simplest solution is not to sort! The
alternative is to write your referencing formulas so that they look up the
appropriate data, using functions such as MATCH, INDEX, VLOOKUP, etc.
 
Jim
As Paul stated, sorting moves the values not the cells. You might be able to use one of these options

1) Define the value directly, instead of in a cell. If you want "Fred" to equal 24, then in Insert>Name>Define, enter Names in workbook: Fred and Refers to: =24

2) Place the named cells in an area that isn't sorted, or on another worksheet, and then refer to the named cells in the list that you are sorting

Good Luck
Mark Graesse
(e-mail address removed)


----- jimfx > wrote: ----

Can someone help me with the following problem in Excel 2000

in a table I have attached serveral cells with unique cell names, th
values in these cells are used in other sheets.

the problem is that when I sort the table, the cell names stay in th
original rowposition; they are not sorted! while their values are. S
Cell names get different values, and other calculations on my othe
sheets get messed up

How can I make the cell names relative instead of absolute

thankx in advance
Ji
 
Back
Top