Hallo,
How are the cell references maintained after sorting the referenced
cells.
Well, an example:

In a workbook are two sheets, Sheet1 and Sheet2. Sheet1 is a ordinary
listing with a subsequent cell reference to Sheet2, like
A.....12%.....Sheet2!G23
B.....33%.....Sheet2!G71
...
Sum...100%.

Sheet2 contains a continuously extended listing and should be sorted
AZ after new entries are added. I tried absolute and relative
referencing, neither worked as it should. That is, if e.g. in the above
example G23 moves to G14, it does NOT change in Sheet1! Absolute
referencing is nonsense as you might suggest.
Any ideas?
Juergen


--
inigo45
------------------------------------------------------------------------
inigo45's Profile: http://www.excelforum.com/member.php...fo&userid=5926
View this thread: http://www.excelforum.com/showthread...hreadid=504269