Deleted Reference Cell

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
 

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

Referencing a cell even if its contents are moved moved/replaced 6
How do I anchor a cell reference? 3
Data Validation - Prevent delete 2
Data Validation - Preventing Delete from Delete Key 2
Formula with Cell reference to include formating? 13
Code to format cells on several worksheets 2
Excel Copy COUNTIF while retaining reference 7
Excel In Excel how can I block the contenent of a cell? 0

Top