+ Reply to Thread
Results 1 to 2 of 2

Make hyperlink target show in the first (ie left most) column

  1. #1
    Registered User
    Join Date
    12-15-2017
    Location
    Cornwall, England
    MS-Off Ver
    2016
    Posts
    7

    Make hyperlink target show in the first (ie left most) column

    Hello clever people,

    I have a simple worksheet and have added hyperlinks to specific sections of the worksheet. Currently when I click on a hyperlink, it works fine, but the target cell is shown in the far right column. I would like the target cell to show in the first available column on the left.

    I have attached a simplified version. Is it possible for the hyperlink target to always show in the 3rd column from the left (ie next to the staff name)?

    Thank you.
    Attached Files Attached Files

  2. #2
    Forum Guru Bo_Ry's Avatar
    Join Date
    09-10-2018
    Location
    Thailand
    MS-Off Ver
    MS 365
    Posts
    7,211

    Re: Make hyperlink target show in the first (ie left most) column

    B2 Yearfrac gives year with decimal, eg 35 years and 6 months is 35.5 and this will fall to 35-45

    =YEARFRAC(A2,TODAY(),3)

    C2 gives you only full year 35 years and 6 months is 35 this will fall to 23-35
    =DATEDIF(A2,TODAY(),"y")


    E5:E9 = {23;35;45;57;65}


    F5 copy down for count
    =INDEX(FREQUENCY(B$2:B$33,$E$5:$E$9),ROWS(F$5:F5))
    Attached Files Attached Files

+ 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. [SOLVED] how to make my code work with target.column instead of target.address
    By dmcgov in forum Excel Programming / VBA / Macros
    Replies: 8
    Last Post: 09-18-2017, 09:29 AM
  2. How to make cells show blank based the cell to the left
    By ScottKiwi in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 09-18-2015, 03:57 PM
  3. Show column to left of named range when clicking hyperlink
    By Crispld in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 12-31-2014, 06:48 PM
  4. [SOLVED] Show row and column values for the target cell
    By Endre111 in forum Excel General
    Replies: 17
    Last Post: 09-09-2014, 12:01 PM
  5. [SOLVED] Replacing 0 in a column with target value in left hand column
    By gretchenwhitcomb in forum Excel Programming / VBA / Macros
    Replies: 11
    Last Post: 04-11-2013, 03:21 PM
  6. Hyperlink target showing on top left corner of screen (Using image not cell)
    By Mo T in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 01-29-2013, 03:23 AM
  7. Replies: 2
    Last Post: 10-27-2005, 04:05 PM

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