Hi,
I have created a somewhat large Excel program in which I previously had to move cells from one spot to another du to lack of space. In retrospective, this procedure was complicated in the manner that I had previously written down the location of the cells that needed my attention (For example: Once activity three is done, manually modify the value of LW36). Of course, once I had moved a series of cells from one spot of my worksheet to another, LW36 was no longer there. The cell LW36 may have moved to RT156. In short, that made things much more complicated.
Now, I have to create a new chart in which specific cells are clearly indicated. However, I was wondering if Excel had a function that could point out in which cell I could find a specific answer instead of giving me the value of the cell.
FOR EXAMPLE:
I need to manually modify de value of cell LW36.
I have created, in my program, a reference chart that tells me what to do and when to do it.
In that same chart, I refer to cell numbers that need to be changed. For example: Once activity three is done, manually modify the value of LW36.
However, the cell LW36 may eventually be relocated and may become RT156.
Is there a function that allows me to follow a cell and tell me where it is?
Once activity three is done, manually modify the value of... FORMULA THAT GIVES ME THE LOCATION OF A SPECIFIC CELL THAT MAY EVENTUALLY BE MOVED.
Thank you!
Ray
Bookmarks