Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
The absolute referenced cell does not move when source cell moves
I'm linking one cell in excel to another cell in a seperate spread sheet and
using the absolute reference $ to allow the formula to move when the source cell moves. This doesn't work unless both spread sheets are open when the cell is moved. What am I doing wrong? |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
The absolute referenced cell does not move when source cell moves
John,
You're not doing anything wrong. Both sheets need to be open for Excel to know that something has moved... The better alternative is to use formulas that find your moving cell: match/index/vlookup etc... HTH, Bernie MS Excel MVP "johnc" wrote in message ... I'm linking one cell in excel to another cell in a seperate spread sheet and using the absolute reference $ to allow the formula to move when the source cell moves. This doesn't work unless both spread sheets are open when the cell is moved. What am I doing wrong? |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
The absolute referenced cell does not move when source cell mo
Bernie,
Thanks I'll try that, you've saved me a lot of frustration! "Bernie Deitrick" wrote: John, You're not doing anything wrong. Both sheets need to be open for Excel to know that something has moved... The better alternative is to use formulas that find your moving cell: match/index/vlookup etc... HTH, Bernie MS Excel MVP "johnc" wrote in message ... I'm linking one cell in excel to another cell in a seperate spread sheet and using the absolute reference $ to allow the formula to move when the source cell moves. This doesn't work unless both spread sheets are open when the cell is moved. What am I doing wrong? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Hit enter in cell & move text down in cell, not go to cell below. | Excel Worksheet Functions | |||
I want chart source data to be relative references, not absolute. | Charts and Charting in Excel | |||
move to another cell within a subtotal report within a macro | Excel Worksheet Functions | |||
Arrows move worksheet rather than cell selection, how fix? | Excel Worksheet Functions | |||
Link to a cell in another workbook by name rather than absolute c. | New Users to Excel |