| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How do I set up a constant reference to a cell that moves?
I have a worksheet that gets it's data from an outside program. When I
refresh the spreadsheet, if a new product is added, it gets inserted alphabetically, moving all of the other cells (rows) down. My worksheets that reference the cells now have the wrong data as the information has moved. Is there a way I can reference that specific data even if it moves to a different cell when I refresh? |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
How do I set up a constant reference to a cell that moves?
how do you refer to the cell?
you might want to change your references to vlookups, index matches or the like "ThirstyDave" wrote: I have a worksheet that gets it's data from an outside program. When I refresh the spreadsheet, if a new product is added, it gets inserted alphabetically, moving all of the other cells (rows) down. My worksheets that reference the cells now have the wrong data as the information has moved. Is there a way I can reference that specific data even if it moves to a different cell when I refresh? |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
How do I set up a constant reference to a cell that moves?
=INDIRECT("A1")
will always refer to A1 -- Regards, Peo Sjoblom "ThirstyDave" wrote in message ... I have a worksheet that gets it's data from an outside program. When I refresh the spreadsheet, if a new product is added, it gets inserted alphabetically, moving all of the other cells (rows) down. My worksheets that reference the cells now have the wrong data as the information has moved. Is there a way I can reference that specific data even if it moves to a different cell when I refresh? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Target cell reference moves when target is cut and pasted | Excel Discussion (Misc queries) | |||
| excel uses what technique to keep a cell reference constant when | Excel Discussion (Misc queries) | |||
| Cell to cell movement with arrow keys moves entire sheet | Excel Worksheet Functions | |||
| How to force a cell value to change if Linked cell moves? | Excel Discussion (Misc queries) | |||
| The absolute referenced cell does not move when source cell moves | Excel Worksheet Functions | |||
Linear Mode
