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 |
All times are GMT +1. The time now is 03:13 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com