| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
maintain worksheet reference
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 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| worksheet reference returns address instead of value | Excel Worksheet Functions | |||
| Worksheet reference behaving funny | Excel Discussion (Misc queries) | |||
| Incrementing rows (or columns) to a reference in another worksheet | Excel Worksheet Functions | |||
| Indirect reference from one worksheet to another | Excel Worksheet Functions | |||
| Reference a cell to get worksheet name | Excel Worksheet Functions | |||
Threaded Mode
