+ Reply to Thread
Results 1 to 13 of 13

Make Hyperlink read cell contents

  1. 07-13-2021, 10:44 AM #1
    anoble1
    anoble1 is offline
    Registered User
    Join Date
    07-22-2008
    Location
    Birmingham
    Posts
    46

    Make Hyperlink read cell contents

    If I have this hyperlink
    HTML Code: 
    Is there a way I can make a column in Excel and 5 rows of part numbers and make the hyperlink read it?
    Can I make this hyperlink generate based on the info in my sheet? 
    Please Login or Register  to view this content.
    These are 2 sample part numbers. I can go up to partNo3,4,5
    Ideas?
    Reply With QuoteRegister To Reply
  2. 07-13-2021, 10:46 AM #2
    AliGW
    AliGW is online now
    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,978

    Re: Make Hyperlink read cell contents

    Yes, but ...

    There are instructions at the top of the page explaining how to attach your sample workbook.
    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.
    Reply With QuoteRegister To Reply
  3. 07-13-2021, 11:26 AM #3
    anoble1
    anoble1 is offline
    Registered User
    Join Date
    07-22-2008
    Location
    Birmingham
    Posts
    46

    Re: Make Hyperlink read cell contents

    So I got it to work below with this formula. How can I turn it into a hyperlink?
    Please Login or Register  to view this content.
    When I manually copy it I get this which is correct.
    HTML Code: 
    Reply With QuoteRegister To Reply
  4. 07-13-2021, 11:29 AM #4
    AliGW
    AliGW is online now
    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,978

    Re: Make Hyperlink read cell contents

    Did you try:

    =HYPERLINK(CONCATENATE(A25,"partNo1=",partNo1,"&","partNo2=",partNo2,,"&","partNo3=",PartNo3,"&","partNo4=",partNo4,"&","partNo5=",partNo5))
    Reply With QuoteRegister To Reply
  5. 07-13-2021, 11:44 AM #5
    anoble1
    anoble1 is offline
    Registered User
    Join Date
    07-22-2008
    Location
    Birmingham
    Posts
    46

    Re: Make Hyperlink read cell contents

    No but didn't work when I just tried it. Value Error
    Last edited by AliGW; 07-13-2021 at 11:47 AM. Reason: PLEASE don't quote unnecessarily!
    Reply With QuoteRegister To Reply
  6. 07-13-2021, 11:49 AM #6
    AliGW
    AliGW is online now
    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,978

    Re: Make Hyperlink read cell contents

    Try without the double comma after partNo2:

    =HYPERLINK(CONCATENATE(A25,"partNo1=",partNo1,"&","partNo2=",partNo2,"&","partNo3=",PartNo3,"&","partNo4=",partNo4,"&","partNo5=",partNo5))
    Reply With QuoteRegister To Reply
  7. 07-13-2021, 11:51 AM #7
    anoble1
    anoble1 is offline
    Registered User
    Join Date
    07-22-2008
    Location
    Birmingham
    Posts
    46

    Re: Make Hyperlink read cell contents

    Good catch. Didn't seem to work still
    Reply With QuoteRegister To Reply
  8. 07-13-2021, 11:52 AM #8
    AliGW
    AliGW is online now
    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,978

    Re: Make Hyperlink read cell contents

    OK - well, sorry - without seeing it in situ, there's nothing more I can do.
    Reply With QuoteRegister To Reply
  9. 07-13-2021, 12:06 PM #9
    anoble1
    anoble1 is offline
    Registered User
    Join Date
    07-22-2008
    Location
    Birmingham
    Posts
    46

    Re: Make Hyperlink read cell contents

    See attachment
    Attached Files Attached Files
    Reply With QuoteRegister To Reply
  10. 07-13-2021, 12:08 PM #10
    AliGW
    AliGW is online now
    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,978

    Re: Make Hyperlink read cell contents

    There's nothing in A25 in your sample workbook.
    Reply With QuoteRegister To Reply
  11. 07-13-2021, 12:19 PM #11
    AliGW
    AliGW is online now
    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,978

    Re: Make Hyperlink read cell contents

    Try this:

    =A25&"partNo1="&partNo1&"&partNo2="&partNo2&"&partNo3="&PartNo3&"&partNo4="&partNo4&"&partNo5="&partNo5
    Attached Files Attached Files
    Reply With QuoteRegister To Reply
  12. 07-13-2021, 12:35 PM #12
    AliGW
    AliGW is online now
    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,978

    Re: Make Hyperlink read cell contents

    If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED.

    Also, 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 With QuoteRegister To Reply
  13. 07-13-2021, 01:07 PM #13
    AliGW
    AliGW is online now
    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,978

    Re: Make Hyperlink read cell contents

    Nothing - not even a thank you???
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next 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 VBA read value in cell
    By ehizzlefosho in forum Excel General
    Replies: 3
    Last Post: 05-13-2016, 03:56 PM
  2. VBA to read cell contents, not formula
    By MAGICofSeth in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 09-29-2013, 12:48 AM
  3. Read cell contents and put value into another cell depending on cell contents
    By neeper67 in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 10-01-2012, 11:15 AM
  4. Excel 2007 : Make a cell take the contents and hyperlink
    By WillD in forum Excel General
    Replies: 1
    Last Post: 07-06-2012, 06:07 AM
  5. [SOLVED] How Can I read Hyperlink Assigned to a cell?
    By modytrane in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 03-18-2012, 11:09 PM
  6. how to make cell read only
    By ndalal in forum Excel Programming / VBA / Macros
    Replies: 13
    Last Post: 03-26-2009, 03:52 AM
  7. How do I make a cell's contents equal to another cell's contents with macro program?
    By mgmcdevitt in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 09-15-2005, 04:44 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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1