Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Cell Reference
I have three worksheets, Sheet1, Sheet2 and Sheet3.
Sheet 1 contains the following data: 1 10 2 9 3 8 4 7 5 6 Sheet 2 contains the following data: 11 20 12 19 13 18 14 17 15 16 Sheet 3 contains the following formulae: Sheet1!A1 Sheet1!B1 Sheet1!A2 Sheet1!B2 Sheet2!A1 Sheet2!B1 Sheet2!A4 Sheet2!B4 When I change the sorting in Sheet1 or Sheet 2, the cell of Sheet3 won't update the "reference" to the "new location", i.e. A1 of Sheet 3 still refers to Sheet1!A1, but in fact, the previous Sheet1!A1 could be Sheet1!A3 after the sorting. Is there any way(s) to get around this problem? Many thanks. |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Cell Reference
On Jun 17, 3:45 am, pa425804
wrote: I have three worksheets, Sheet1, Sheet2 and Sheet3. Sheet 1 contains the following data: 1 10 2 9 3 8 4 7 5 6 Sheet 2 contains the following data: 11 20 12 19 13 18 14 17 15 16 Sheet 3 contains the following formulae: Sheet1!A1 Sheet1!B1 Sheet1!A2 Sheet1!B2 Sheet2!A1 Sheet2!B1 Sheet2!A4 Sheet2!B4 When I change the sorting in Sheet1 or Sheet 2, the cell of Sheet3 won't update the "reference" to the "new location", i.e. A1 of Sheet 3 still refers to Sheet1!A1, but in fact, the previous Sheet1!A1 could be Sheet1!A3 after the sorting. Is there any way(s) to get around this problem? Many thanks. Most would not consider this a problem, that is why Excel works this way. What are you trying to do? I'm guessing your actual sheets aren't quite this simple. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Nesting a sheet name reference within a cell reference??? | Excel Discussion (Misc queries) | |||
Changing sheet reference to cell reference | Excel Worksheet Functions | |||
absolute cell reference A spreadsheet cell reference that does no | Excel Discussion (Misc queries) | |||
problem with cell reference in =sum(offset(cell reference,x,y,z,a)). Want cell ref to be variable. | Excel Worksheet Functions | |||
Problem with =sum(offset(cell reference,w,x,y,z). I want cell reference to be variable | Excel Worksheet Functions |