The absolute referenced cell does not move when source cell moves

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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?
 
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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel VBA to move cursor from 1 cell to another, once original cell is filled with data. 3
absolute reference fill 1
How to get range names to Apply across multiple tabs 1
Move cell and maintain reference 4
Excel Columns moving up and down on their own in a worksheet. What Goes? 2
Excel 2003 make 1 date cell automatically change another date cell 3
excell 2007 moving data in cell 4
moving from one sheet to another from a cell of a sheet 1

Back
Top