hyperlink & sheetname

  1. A

    Hyperlink with Criteria

    Hi guys. Is there a way to edit the below formula so that the worksheet name is referenced to a cell?? - "2020" is a cell. =HYPERLINK("#"&ADDRESS(MATCH(A4,'2020'!A:A,0),8,1,1,"2020"),"Link")
  2. G

    Hyperlink that links to a cell relative to the sheet the hyperlink is located in

    Hi, I'm creating an excel sheet for a friend who is even less well versed in excel than I am and I'm having trouble making a hyperlink that just points to a cell, no matter what sheet that the hyperlink is in. Here's an example: I have a workbook with one sheet in it, Sheet1. In cell A1 of...
  3. M

    Hyperlink help

    I am new to the forum and new to coding so please forgive my inexperience! I have the following code (I didn't create it) that searches for a worksheet with the same name as the list of sheet names and creates a hyper link to the worksheet where the name is found. The worksheets are already...
  4. T

    Concatenated hyperlink

    Hi I am trying to figure out a concatenated hyperlink. =HYPERLINK(CONCATENATE("[CSUL.xlsx]",A12,"!A7"),"Goto") This is what I have got so far it links to the workbook CSUL.xlsx but not the Sheet and Cell. The sheet name is in Cell A12. I think this is a problem with Parenthesis. If not...
  5. S

    Issue with hyperlink formula when a space character is in the destination worksheet name

    I'm using the formula below to create a hyperlink to another worksheet in the same workbook. The formula parses out the destination worksheet from another cell (A12 in the example below) using the carat delimiter. The formula works perfectly as long as the destination worksheet does not...
  6. C

    Double-Click "Hyperlink" to Hidden Sheets

    Hey All, I've come here with a question about a code that I'm currently running to act as a method to "Hyperlink" to hidden sheets. I found the code on this forum, but it was back from 2011. The code works perfectly well until MERGED cells. Private Sub Worksheet_Activate() Dim sh As...
  7. C

    Create custom Link to select multiple tabs for editing

    I have a large excel file with ~100 tabs. Between each grouping of tabs (by region), I have placeholders with no data but simply the region name to facilitate adding across the file. When I want to edit all of the data tabs at once, I have manually select all of them, or else choose all tabs...
  8. Q

    Hyperlink

    Can anyone tell me why this does not work? Worksheets("PR Database").Range("C3").Value = "=HYPERLINK("[PR 2015.xlsm]4!A4","test")" I want to place a Hyperlink in sheet PR Database cell C3 that points to sheet 4 cell A4 and called test Thanks for any and all help.
  9. M

    To Summarize the sheet with hyperlink

    I need to summarize the sheet with sheet name as " Summary sheet" with hyperlink. In the below code , it is summarize but file name is not proper and i need to do manually the hyperlink. Private Sub ListSheets() 'list of sheet names starting at A1 Dim Rng As Range Dim i As Integer...
  10. A

    Hyperlink macro

    I don’t have a good knowledge in VBA scripting. I want to create a workbook for my customers, there will a master sheet. The master sheet will contain the list of my customer with a unique serial number. There will be a “detailed sheet” for every customer. So that I can find a customer by...
  11. C

    Macro to insert a hyperlink in several worksheets

    I am creating several books that have several worksheets and each sheet needs a link to a summary sheet. I am lost trying to create a macro that will do this. If in addition, I could run a macro that will insert a hyperlink from the summary sheet back to each worksheet... that would be...
  12. M

    Hyperlinks in Macro

    Hi, Thank you all for your help in advance. I need help writing the code to create a hyperlink that links to a sheet titled the same as the the cell that is currently being selected. I also want the hyperlink to be titled the same as the value already in the current cell. I want the subaddress...
  13. G

    Macro needed to create summary tab of all worksheet names & then hyperlink to them

    I have a macro that inserts a new tab in my workbook and lists the name of all the other tabs within the same workbook. I like using this macro to create a summary sheet of all the tabs within my workbook, however how do I modify this macro so that each of the tab names on my summary sheet turn...
  14. H

    Hyperlink Macro Loop with Error Handling????

    OK, for some reason (someone probably knows why) when I use the macro below to add a hyperlink to all cells in one column of a table the loop will reach a value that is just numbers and spit out an error. the values in the cells are the names of other worksheets in the file. and the values are...
  15. B

    Hyperlink with VBA: Reference is not valid

    I have the following code. It lists the sheets names in a sheet called "Index" and then hyperlinks each sheet name back to their respective sheet. However, when I go to click on the hyperlink it tells me that the reference is not valid. Does anyone know why that error would be happening...
  16. J

    How to Link Worksheets

    I have workbook with worksheet 1 and worksheet 2. I need to creat a link on Worksheet 1 so that when you click it it will take you to worksheet 2
  17. B

    VBA to create index of worksheets with no link backs

    I have been scouring the web and have found VBA codes that will create a hyperlinked index of all the worksheets in the my document. But I am running into a problem. I have two particular worksheets that update automatically from an external data source and I don't want to have any hyperlink...
  18. J

    Hyperlink to sheets

    The following code lists the sheet names in a workbook starting at A6 on the "Summary" sheet. How do I modify the code to change the listed sheet names to hyperlink to each of the named sheets? Sub InsertNames() Worksheets("Summary").Unprotect Dim N As String Dim i As Long, r As Long...
  19. K

    Hyperlink with variable workbook and sheet name

    Hello there! How can I use "HYPERLINK(link_location, [friendly_name])" with variable workbook and sheet name and spece between their names. I linked the "[friendly_name]" to sheet name.The argument "[friendly_name]" doesn't allow the hyperlink to work if there's a space between either...
  20. R

    Dynamic Hyperlink - Type a region name into a cell which drives a hyperlink

    Hello everyone, I have a spreadsheet with about 80+ sheets. I want to hyperlink to them. I have a contents page at the front which is fine. But within the spreadsheet I want to create a dynamic hyperlink. I have sheets named Region 1, Region 2 up to region 40. I want to be able to type...

Some videos you may like

This Week's Hot Topics

  • Finding issue in If elseif else with For each Loop
    Finding issue in If elseif else with For each Loop I have tried this below code but i'm getting in Y column filled with W005. Colud you please...
  • MsgBox Error
    Hi Guys, I have the below error show up when i try and run my macro in File1 but works fine if i copy and paste the same code into file2. [ATTACH...
  • CELL FORMAT - IF CONDITION
    My Cell Format is [B]""0.00" Cr". [/B]But in the cell, it is showing 123.00 for editing. (123 is entry figure). (Data imported from other...
  • Show numbers nearly the same
    Is this possible. I have a number that can change very time eg 0.00001234 Then I have a lot of numbers 0.0000001, 0.0000002, 0.00000004...
  • Please i need your help to create formula
    I need a formula in cell B8 to do this >>if b1=1 then multiply ( cell b8) by 10% ,if b1=2 multiply by 20%,if=3 multiply by 30%. Thank you in...
  • Got error while adding column and filter
    Got error while adding column and filter In column Z has some like "Success" and "Error". I want to add column in AA if the Z cell value is...
Top