+ Reply to Thread
Results 1 to 5 of 5

Locating cells?

  1. #1
    Registered User
    Join Date
    05-12-2016
    Location
    Canada
    MS-Off Ver
    Microsoft Office Famille et Étudiant 2019
    Posts
    26

    Locating cells?

    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
    GO! WINGS! GO!

  2. #2
    Registered User
    Join Date
    03-22-2020
    Location
    Malaysia
    MS-Off Ver
    2013 and 365 Pro Plus
    Posts
    56

    Re: Locating cells?

    Perhaps this could shed some light

    Formulas Menu
    Formula Auditing Ribbon
    Trace

  3. #3
    Registered User
    Join Date
    05-12-2016
    Location
    Canada
    MS-Off Ver
    Microsoft Office Famille et Étudiant 2019
    Posts
    26

    Re: Locating cells?

    I'll look into it. Thanks!

  4. #4
    Valued Forum Contributor
    Join Date
    06-22-2018
    Location
    Blackpool, England
    MS-Off Ver
    2019
    Posts
    408
    Quote Originally Posted by WINGSWINTHECUP View Post
    However, the cell LW36 may eventually be relocated and may become RT156.com
    Is there a function that allows me to follow a cell and tell me where it is
    I hate to sound all nerdy and pedantic, but what you're moving isn't actually the cell - it's the function the cell has in the design of your project - not something excel can keep track of.

    This is the purpose that named ranges are designed for. So rather than trying to keep track of what you're moving where, it might be better to give names to the affected cell ranges, change references in formulae and code, THEN start to edit the layout of your worksheet by redefining what the named range points to.

    You could, technically, use the indirect() function but that would involve a redesign of the project just for the purpose of crafting an interim solution - you might as well go the whole hog in the first place.

    Another, albeit crude, approach would be to do a "search and replace" to find references that need changing, but that's problematic because searching for "A1" wouldn't find "$A$1"etc.

    Biex's suggestion is a starting point.

    Tim
    Never stop learning!
    <--- please consider *-ing !

  5. #5
    Registered User
    Join Date
    05-12-2016
    Location
    Canada
    MS-Off Ver
    Microsoft Office Famille et Étudiant 2019
    Posts
    26

    Re: Locating cells?

    Thank you for the suggestions Tim. It does give me some insight on some options I may consider for future development. However, in this particular situation, it doesn't really help. What I'm trying to achieve is to create a "to do list" in which I will write down:

    STEP 3: Go to cell NH145 and manually modify the value of the cell.

    Now, in the past, I have needed to relocate some charts in my Excel program (seldomly, but it has happened before). If I do eventually relocate chart "X" in which cell NH145 is located and moved it to cell ZY155, I want the reference of NH145 in my "to do list" to automatically change to ZY155. In short, I need to know where the cell is located in my large Excel program.

    This being said, I do appreciate you taking the time to try to help me with my problem. So, many thanks!

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Help with locating errors in cells
    By Simon Jones in forum Excel General
    Replies: 5
    Last Post: 02-07-2014, 06:35 AM
  2. VBA: locating any error cells in a given column
    By niceguy21 in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 04-25-2013, 11:56 AM
  3. locating cells that add up to a given number?
    By BSBECK in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 09-29-2008, 02:30 PM
  4. Locating corresponding cells in another worksheet
    By melkj in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 07-07-2007, 04:44 AM
  5. locating cells using a variable
    By adsxvii in forum Excel General
    Replies: 1
    Last Post: 03-17-2007, 07:01 PM
  6. Locating cells with same information
    By GAWood in forum Excel General
    Replies: 5
    Last Post: 11-01-2006, 12:25 AM
  7. Locating linked cells in Excel
    By NBV in forum Excel General
    Replies: 3
    Last Post: 11-29-2005, 04:55 PM
  8. Locating min/max number of x adjacent cells
    By Paul987 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 07-18-2005, 12:42 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1