+ Reply to Thread
Results 1 to 2 of 2

Creating Hyperlinks from multiple cells

  1. #1
    Registered User
    Join Date
    02-01-2017
    Location
    Minnesota
    MS-Off Ver
    2010
    Posts
    4

    Creating Hyperlinks from multiple cells

    I would like to create hyperlinks from 2 different cells with display text that says "Link" or the text from one cell.

    Column A = a bill number formatted as 000#
    Column B = standard url that forms a link when the correct "000#" in column a is added after the "hf" at the end of w.house.leg.state.mn.us/bills/Information/BillNumber?FileNumber=hf
    Column C = is where i would like the hyperlink combined from A+B, preferably the hyperlink text displayed would say link or the Column A number (000#).

    So far I've been able to combine the two using this formula: =B1&""&TEXT(A1,"0000"), but this only gets the correct link created. It does not create a hyperlink I can click on. Again I would also prefer that it display text instead of the link.

    I've seen some possible MACRO solutions to almost similar problems but I am not finding one that works. It could be because I am very green when it comes to Macros and am not doing it correctly. Attached spreadsheet shows exactly what I am trying to do.
    Last edited by josephj; 04-06-2021 at 02:14 PM.

  2. #2
    Forum Guru
    Join Date
    07-25-2011
    Location
    Florida
    MS-Off Ver
    Excel 2003
    Posts
    9,606

    Re: Creating Hyperlinks from multiple cells

    Try something like this...

    Formula: copy to clipboard
    Please Login or Register  to view this content.


    The HYPERLINK function
    Surround your VBA code with CODE tags e.g.;
    [CODE]your VBA code here[/CODE]
    The # button in the forum editor will apply CODE tags around your selected text.

+ 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] Creating multiple hyperlinks problem. Please help.
    By F1ash in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 03-16-2021, 07:02 AM
  2. [SOLVED] Creating multiple rows hyperlinks from text in different cells in a Macro
    By p1awn in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 06-19-2013, 01:16 PM
  3. Creating Multiple Hyperlinks
    By @Xel in forum Excel General
    Replies: 1
    Last Post: 06-04-2013, 01:42 AM
  4. Excel 2007 : Creating multiple hyperlinks in the same cell
    By ballj_35@yahoo.com in forum Excel General
    Replies: 3
    Last Post: 01-02-2012, 02:14 PM
  5. Creating Multiple Hyperlinks
    By julvaz in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 02-28-2007, 02:53 PM
  6. Creating multiple hyperlinks
    By markmerid in forum Excel General
    Replies: 1
    Last Post: 09-21-2006, 09:00 AM
  7. Creating multiple hyperlinks in one cell?
    By OCDetails.com in forum Excel General
    Replies: 1
    Last Post: 02-26-2005, 07:18 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