Deleted Reference Cell

  • Thread starter Thread starter rbmcclen
  • Start date Start date
R

rbmcclen

Hi,
How do I make excel continue to reference a cell location when th
previous cell being referenced is deleted?
If I have cell A1=B1 and delete B1 it changes A1 to be #REF!
How do I make it continue to point to B1s location so that the new dat
that would fall into B1 is now referenced?

Thanks in advanc
 
Back
Top