+ Reply to Thread
Results 1 to 10 of 10

Inserting Multiple Hyperlinks in a Single Column

  1. #1
    Registered User
    Join Date
    09-15-2010
    Location
    USA
    MS-Off Ver
    Excel 2007
    Posts
    35

    Inserting Multiple Hyperlinks in a Single Column

    Hi,

    I need help with inserting multiple hyperlinks in a single column and be able to auto create the link by typing a particular code. For eg; in 'entrybook2', under dyer column I have entered codes like ma, rz, jd. I require that if I type ma, it should directly go to the worksheet 'Mohammad Ali Dyer' to pcs received sheet. Similarly, if I type rz and jd, should go directly to their respective sheets. I should not need to insert hyperlink each and everytime I make an entry.

    Is this possible?
    Attached Files Attached Files

  2. #2
    Forum Expert Logit's Avatar
    Join Date
    12-23-2012
    Location
    North Carolina
    MS-Off Ver
    Excel 2019 Professional Plus - 2007 Enterprise
    Posts
    6,986

    Re: Inserting Multiple Hyperlinks in a Single Column

    .

    Found this on a website. Quick and easy.

    Use the usual hyperlink dialogue box and select the file but before doubleclicking it to create the hyperlink, click the 'bookmark' button (on the right in the dialogue box) - this opens to show you a list of all the sheets in the selected file so you can choose what sheet to link to. easy!

  3. #3
    Registered User
    Join Date
    09-15-2010
    Location
    USA
    MS-Off Ver
    Excel 2007
    Posts
    35
    Quote Originally Posted by Logit View Post
    .

    Found this on a website. Quick and easy.

    Got this part. But is there a way to predefine the link. For eg if I type ma in a particular column it should automatically create hyperlink to a particular worksheet
    Last edited by diksha_16; 07-25-2017 at 06:17 AM.

  4. #4
    Registered User
    Join Date
    09-15-2010
    Location
    USA
    MS-Off Ver
    Excel 2007
    Posts
    35

    Re: Inserting Multiple Hyperlinks in a Single Column

    Can someone please help me? Need two things automatic hyperlinking and multiple hyperlinking in one column

  5. #5
    Forum Expert Logit's Avatar
    Join Date
    12-23-2012
    Location
    North Carolina
    MS-Off Ver
    Excel 2019 Professional Plus - 2007 Enterprise
    Posts
    6,986

    Re: Inserting Multiple Hyperlinks in a Single Column

    .
    The following macro is semi-automated. It will ask if you want to create a hyperlink. If "YES", it brings up the File Browser enabling selection of a file.
    It does not provide a means to select a specific sheet in a file. It can be edited to do the things you need.

    I'm thinking of a CASE SELECT scenario.

    Case MA can include code to create the hyperlink you need when you type MA into a cell.
    Case RZ can do the same
    Case JD also

    You could create as many CASE SELECT options as required.

    Please Login or Register  to view this content.

  6. #6
    Registered User
    Join Date
    09-15-2010
    Location
    USA
    MS-Off Ver
    Excel 2007
    Posts
    35
    Quote Originally Posted by Logit View Post
    .
    The following macro is semi-automated. It will ask if you want to create a hyperlink. If "YES", it brings up the File Browser enabling selection of a file.
    It does not provide a means to select a specific sheet in a file. It can be edited to do the things you need.

    I'm thinking of a CASE SELECT scenario.

    Case MA can include code to create the hyperlink you need when you type MA into a cell.
    Case RZ can do the same
    Case JD also

    You could create as many CASE SELECT options as required.

    Please Login or Register  to view this content.
    Where do I enter this code?

  7. #7
    Administrator FDibbins's Avatar
    Join Date
    12-29-2011
    Location
    Duncansville, PA USA
    MS-Off Ver
    Excel 7/10/13/16/365 (PC ver 2310)
    Posts
    52,917

    Re: Inserting Multiple Hyperlinks in a Single Column

    Quote Originally Posted by diksha_16 View Post
    Can someone please help me? Need two things automatic hyperlinking and multiple hyperlinking in one column
    1st, please wait at least a day before "bumping" your thread please.

    2nd, if you have a list of sheet names in, saw, column A starting in A2, this will use that name, and create a HL to cell A1 in that sheet...
    =IFERROR(HYPERLINK("#"&"'"&INDEX(Sheetnames,ROWS($A$2:A2))&"'!A1",INDEX(Sheetnames,ROWS($A$2:A2))),"")
    You can then copy that down as needed
    1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
    2. If your question is resolved, mark it SOLVED using the thread tools
    3. Click on the star if you think someone helped you

    Regards
    Ford

  8. #8
    Registered User
    Join Date
    09-15-2010
    Location
    USA
    MS-Off Ver
    Excel 2007
    Posts
    35
    Quote Originally Posted by FDibbins View Post
    1st, please wait at least a day before "bumping" your thread please.

    2nd, if you have a list of sheet names in, saw, column A starting in A2, this will use that name, and create a HL to cell A1 in that sheet...
    =IFERROR(HYPERLINK("#"&"'"&INDEX(Sheetnames,ROWS($A$2:A2))&"'!A1",INDEX(Sheetnames,ROWS($A$2:A2))),"")
    You can then copy that down as needed
    My original post was on 23-7-17 and I wrote back on 25-7-17. I realise what you are trying to say, but in no way am I trying to spam or bump up my thread.

  9. #9
    Forum Expert Logit's Avatar
    Join Date
    12-23-2012
    Location
    North Carolina
    MS-Off Ver
    Excel 2019 Professional Plus - 2007 Enterprise
    Posts
    6,986

    Re: Inserting Multiple Hyperlinks in a Single Column

    .
    This macro should be pasted in the sheet level module.

    Right click on the sheet tab you are working with. Select VIEW CODE.

    Paste the macro in the VBE window (large window on right side.

    Anytime you make a change in that sheet, it will ask if you want to create a hyperlink to the workbook.


    Please Login or Register  to view this content.
    Keep in mind the above macro only creates a link to the workbook. It stops there. Won't create a link to the desired page in the workbook. That's where I felt if you adjust the code
    to include a SELECT CASE statement you could obtain the goal you are seeking.

    Perhaps someone else has a better idea.

  10. #10
    Registered User
    Join Date
    09-15-2010
    Location
    USA
    MS-Off Ver
    Excel 2007
    Posts
    35

    Re: Inserting Multiple Hyperlinks in a Single Column

    I did not understand the formula so I am not sure how to test it. Can you please give me an example by inserting the formula in the worksheets I attached above?

+ 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] Inserting multiple rows into single row
    By nur2544 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 06-12-2015, 11:28 AM
  2. [SOLVED] Can you fit multiple hyperlinks in a single cell on a Excel Spreadsheet
    By jonnydur in forum Excel - New Users/Basics
    Replies: 4
    Last Post: 05-10-2012, 10:16 AM
  3. Replies: 2
    Last Post: 04-05-2012, 03:45 PM
  4. Inserting multiple values within a single cell.
    By maacmaac in forum Excel General
    Replies: 1
    Last Post: 09-25-2007, 05:41 PM
  5. [SOLVED] Multiple hyperlinks in a single cell
    By lorildemarco in forum Excel General
    Replies: 3
    Last Post: 08-07-2006, 03:10 PM
  6. VBA- inserting multiple cell values into single textbox
    By VBA_MAN in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 03-14-2006, 09:45 AM
  7. [SOLVED] Excel should allow multiple hyperlinks in a single cell
    By mrpb in forum Excel General
    Replies: 3
    Last Post: 01-18-2005, 01:06 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