Closed Thread
Results 1 to 2 of 2

Dynamic Hyperlink to last column. Goto A1 to B1 to C1....Data set grows hyperlink to D1

  1. #1
    Registered User
    Join Date
    08-05-2018
    Location
    USA
    MS-Off Ver
    2010
    Posts
    3

    Dynamic Hyperlink to last column. Goto A1 to B1 to C1....Data set grows hyperlink to D1

    Hello

    I'm trying to use the hyperlink function to create a link that will take me to the end of the data set in the last column even when more data is added.


    The data is entered beginning in B1 then C1 then D1..... I would like to create a dynamic hyperlink that goes to the last column as more data is entered.

    I know how to create a dynamic hyperlink to take me to the last row of a column. But in this situation the data is transposed and the hyperlink needs to go to the last column.

    Thanks

  2. #2
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Retired in Ipswich, Suffolk, but grew up in Sawley, Derbyshire (England)
    MS-Off Ver
    MS 365 Subscription Insider Beta Channel v. 2404 (Windows 11 22H2 64-bit)
    Posts
    80,830

    Re: Dynamic Hyperlink to last column. Goto A1 to B1 to C1....Data set grows hyperlink to D

    This is a duplicate and as such will be closed.

    Go to your original thread here: https://www.excelforum.com/excel-gen...of-column.html

    You can change the title there to what you have used here. Add any extra detail there.
    Ali


    Enthusiastic self-taught user of MS Excel who's always learning!
    Don't forget to say "thank you" in your thread to anyone who has offered you help.
    You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.

    Forum Rules (updated August 2023): please read them here.

Closed Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Replies: 6
    Last Post: 08-07-2018, 08:43 PM
  2. Replies: 7
    Last Post: 02-07-2018, 11:00 AM
  3. macro to follow variable hyperlink or Application.Goto
    By mrusten88 in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 04-03-2015, 09:59 AM
  4. [SOLVED] Graph grows as data grows
    By butlerar in forum Excel Charting & Pivots
    Replies: 3
    Last Post: 01-31-2014, 06:56 PM
  5. [SOLVED] Excel 2010 Create a macro to check if cell contains hyperlink then apply hyperlink style
    By chasidar in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 09-12-2013, 04:48 AM
  6. Replies: 1
    Last Post: 02-23-2013, 05:18 AM
  7. Replies: 1
    Last Post: 09-20-2012, 08:17 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