Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
johnc
 
Posts: n/a
Default 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   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Bernie Deitrick
 
Posts: n/a
Default 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   Report Post  
Posted to microsoft.public.excel.worksheet.functions
johnc
 
Posts: n/a
Default 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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Hit enter in cell & move text down in cell, not go to cell below. raoul_duke Excel Worksheet Functions 4 April 2nd 23 08:37 PM
I want chart source data to be relative references, not absolute. Bob Mc Charts and Charting in Excel 1 April 7th 06 02:53 PM
move to another cell within a subtotal report within a macro NoelH Excel Worksheet Functions 1 August 31st 05 03:02 PM
Arrows move worksheet rather than cell selection, how fix? grenada49 Excel Worksheet Functions 3 May 17th 05 09:05 PM
Link to a cell in another workbook by name rather than absolute c. Marc G New Users to Excel 2 January 5th 05 09:15 PM


All times are GMT +1. The time now is 08:49 AM.

Powered by vBulletin® Copyright ©2000 - 2023, Jelsoft Enterprises Ltd.
Copyright 2004-2023 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"