+ Reply to Thread
Results 1 to 5 of 5

Linking to words on same sheet

  1. #1
    Registered User
    Join Date
    10-02-2019
    Location
    Pooler, Ga
    MS-Off Ver
    Pro 2016
    Posts
    21

    Linking to words on same sheet

    I need to set up a sheet with two columns. One is the destination cell, and the other will be a hyperlink cell referencing a cell in the Destination Column. Here is the thing though. I will occasionally need to resort my destination column. But I want the hyperlink column to be able to reference that particular word location in the modified destination column, and not reference the cell space. I have created a sample spread sheet to reflect that. I have an original configuration, and a modified configuration. In the original, the link list will access the appropriate destination cell. I did a random (Z-A) sort on the destination list. The Alpha Link accesses the Pi destination. But I need the Alpha Link to access the Alpha destination new location.

    As I said, the enclosed file is simply an example. In the file that I will be working with, all of the names for the destination will be unique. FYI, while I am not an Excel dummy, I also don't have an extreme amount of experience working with formulas. So, whatever the solution is, please present it step by step, with illustrations. At least, I believe that I have attached the file. I don't see it. So, if I did not do that properly, and if my explanation is not clear, let me know, and I will rectify either or both oversights.

    Thanks.

    EDIT: After posting, I see the file that I uploaded. Hopefully, others will see it also.
    Attached Files Attached Files

  2. #2
    Forum Guru
    Join Date
    03-02-2006
    Location
    Los Angeles, Ca
    MS-Off Ver
    Win10/MSO2016
    Posts
    13,001

    Re: Linking to words on same sheet

    Select the link list in column C, right click and remove hyperlinks.
    Create name ranges:
    Please Login or Register  to view this content.


    Cell C3, et al., typical:
    Please Login or Register  to view this content.
    notice: #
    I sorted column A by column B for testing...
    Attached Files Attached Files
    Ben Van Johnson

  3. #3
    Forum Expert wk9128's Avatar
    Join Date
    08-15-2020
    Location
    China Shanghai
    MS-Off Ver
    365 V2505 and WPS V2024(12.1.0.18543)
    Posts
    4,113

    Re: Linking to words on same sheet

    Try this code
    COLUMN A , COLUMN E , After adjusting the order, follow RUN Button click COLUMN C ,COLUMN G Will connect to the corresponding position

    Please Login or Register  to view this content.
    Attached Files Attached Files
    Last edited by wk9128; 04-27-2025 at 10:00 PM.

  4. #4
    Registered User
    Join Date
    10-02-2019
    Location
    Pooler, Ga
    MS-Off Ver
    Pro 2016
    Posts
    21

    Re: Linking to words on same sheet

    Wow, this will definitely move my knowledge base along. You forgot to mention how/where to create the name list. Remember, I don't have all the Excel skills. Fortunately, with enough digging, I found the answer in the file that you uploaded. But it took a while. One doesn't know where to look if one doesn't know where to look.

    This will be a bit of a set up chore (The file that I need to use it on contains roughly forty distinct reference names) But, once I do, it should fly with no problem. So, I am marking this thread as complete/resolved.
    Last edited by Tedejr; 04-28-2025 at 02:47 PM.

  5. #5
    Forum Expert wk9128's Avatar
    Join Date
    08-15-2020
    Location
    China Shanghai
    MS-Off Ver
    365 V2505 and WPS V2024(12.1.0.18543)
    Posts
    4,113

    Re: Linking to words on same sheet

    @Tedejr You're Welcome. Glad to help . Thank You for the feedback.

    If you finally get a solution please mark your thread as SOLVED:
    - Click Thread Tools above your first post,you will see the word PREFIX on the upper left, press the button to select [SOLVED] select "Mark your thread as Solved".
    - you may not be aware that you can thank those who have helped you by clicking the small star icon located in the lower left corner of the post in which the help
    was given. By doing so you can add to the reputation(s) of those who helped.

+ 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. Linking Numbers to Words Across Different Sheets
    By darthy22 in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 01-10-2020, 09:58 PM
  2. Linking of Excel sheet balance to main snap sheet
    By vizagsuresh in forum Excel General
    Replies: 1
    Last Post: 06-30-2018, 03:55 AM
  3. [SOLVED] Vba code to color text in sheet 1 based on key words present in next sheet.
    By sapnawat in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 01-17-2018, 04:26 AM
  4. Replies: 1
    Last Post: 06-14-2016, 06:21 PM
  5. linking incompatible spreadsheeets and linking data in summary sheet
    By tcarter1208 in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 04-24-2015, 04:02 AM
  6. Linking information to key words?
    By Supersy in forum Excel General
    Replies: 1
    Last Post: 02-14-2011, 01:34 PM
  7. Replies: 2
    Last Post: 12-22-2008, 02:01 AM

Tags for this Thread

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