hyperlink & sheetname

Ok, all, first time posting on any forum. Just been sitting in the back, reading and learning. But now I'm stuck and decided to ask for help. I need to assign a created image with a hyperlink to a hidden sheet, using a variable address based on the value of a cell. EV36 would be the location of...

Hi All I need some help please, I need to be able off a button press (i can create the Button etc.) Add a New work sheet Report (copy of a pre-existing Report) Have code for this below. Re-Name that sheet depending on the name in the current active cell Hyperlink link the new report off the...

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")

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...

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...

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...

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...

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...

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...

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.

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...

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...

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...

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...

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...

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...

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...

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

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...

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...