| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Deleted Reference Cell
Hi, How do I make excel continue to reference a cell location when the 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 data that would fall into B1 is now referenced? Thanks in advance -- rbmcclen ------------------------------------------------------------------------ rbmcclen's Profile: http://www.excelforum.com/member.php...o&userid=36367 View this thread: http://www.excelforum.com/showthread...hreadid=563279 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do I anchor a cell reference? | Excel Discussion (Misc queries) | |||
| Reference Cell Color From Other WorkSheets | Excel Worksheet Functions | |||
| How to have a variable cell reference across sheets? | Excel Discussion (Misc queries) | |||
| Possible Lookup Table | Excel Worksheet Functions | |||
| Cell Reference Math | Excel Worksheet Functions | |||
Linear Mode
