+ Reply to Thread
Results 1 to 3 of 3

Creating a link to a sheet after selecting in a list.

  1. 04-26-2017, 04:02 PM #1
    Ginge1267
    Ginge1267 is offline
    Registered User
    Join Date
    11-07-2013
    Location
    Derbyshire, England
    MS-Off Ver
    Excel 2016
    Posts
    52

    Creating a link to a sheet after selecting in a list.

    Hi Guys, I hope you can help, please see the attached file.

    Column A has cells with a Data validation list to select.
    Column B has a lookup to provide the Hyperlink to the sheet (eventually).
    Columns D and E is the data for the lookup.

    So I would like to select a sheet name from column A, and in column B I get a Hyperlink (or similar) to the sheet listed in A.

    My current Lookup in B just gives me a #NAME? result at the moment, please can you help?

    Sorry if the attachment is done incorrectly.


    https://www.excelforum.com/attachmen...1&d=1493236841
    Attached Files Attached Files
    Reply With QuoteRegister To Reply
  2. 04-26-2017, 05:04 PM #2
    davesexcel
    davesexcel is offline
    Forum Moderator davesexcel's Avatar
    Join Date
    02-19-2006
    Location
    Regina
    MS-Off Ver
    MS 365
    Posts
    13,482

    Re: Creating a link to a sheet after selecting in a list.

    This should do it, in B2
    =HYPERLINK("#" & "'" & A2 & "'!$A$1",A2)
    ,
    Xlorate.com, Selection Codes, YouYube Channel
    Reply With QuoteRegister To Reply
  3. 04-26-2017, 05:38 PM #3
    Ginge1267
    Ginge1267 is offline
    Registered User
    Join Date
    11-07-2013
    Location
    Derbyshire, England
    MS-Off Ver
    Excel 2016
    Posts
    52

    Re: Creating a link to a sheet after selecting in a list.

    Davesexcel, you are a genius sir.

    Works perfectly thanks very much.
    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. Need help creating a list of hyperlinks that link to every 61 rows
    By pasqualebaldi in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 07-14-2015, 02:09 PM
  2. info in another sheet after selecting result from drop down list.
    By AzlanFirmansyah in forum Excel - New Users/Basics
    Replies: 5
    Last Post: 04-14-2013, 04:49 PM
  3. creating hyper link from one sheet to another using macros in Excel
    By rameshjey in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 02-21-2013, 03:52 AM
  4. [SOLVED] Print sheet as PDF after selecting each of the option in validation list
    By ron2k_1 in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 05-25-2012, 11:18 AM
  5. error when selecting cells after creating new sheet
    By Matuna in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 07-30-2010, 09:11 AM
  6. Creating a drop-down list & selecting multiple items
    By Jamie6521 in forum Excel General
    Replies: 1
    Last Post: 02-08-2009, 02:53 AM
  7. creating a link to another sheet in the same file
    By Justin Loreth in forum Excel General
    Replies: 2
    Last Post: 02-22-2006, 12:10 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