hyperlink

Dear All, I have an excel file which contains students sheet with month name and school fee challans sheet. A) When I click on the roll no. then print of challans on other sheet should be sent to printer with this student record: 1) Roll no. here as challan no there 2) student name and...

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. In advance, sorry for my english. I want to link value to other excel when i click cell i dont want to go other sheet for explain, i want it show when i aproach to cell. Please look at images

Hi all, I am still learning with excel and have been rattling my brain over the past few days of how to get this to work! So here we go.... In worksheet "Log", cells C2, C3, C4 will have values inserted from a userform with numbers like 732, 733, 744 etc and these cells will be hyperlinked. I...

I found a script for inserting hyperlinked photos that works well with one column. However, I would like to know how to insert for multiple columns like I, J, K, L, M, N. Each column will have several rows of hyperlinks. Here is the code I found that works well for single column. Just need to...

Hi! This is my first thread on this forum, hope you understand me and help :) I am working with excel for my personal project. I would to make a macro_button which changes formulas/text for hyperlink. I have tried many options with sendkeys in macro but still have same problem. There are my...

Formula returns address of last non-blank cell in column A: ="A"&MATCH(2,1/(A:A<>""),1) e.g.: A1000 Trying to turn it into a Hyperlink with: =HYPERLINK("A"&MATCH(2,1/(A:A<>""),1)) results in below error, when clicking on it. How to turn last non-blank cell address formula into a Hyperlink...

Hi, My data looks something like this: A B C 1 Name: Date Of Birth: Reference: 2 SMITH, John 12/03/1988 K3472 3 JONES, Kayla 27/04/1962 K7895 4 RUSS, Tim 08/07/2022 I want the names (A2:A4) to be hyperlinks using the data from Column C. The link to the website...

Hello, I have the below code in Excel that generates emails. I'd like to add a hyperlink to a website in the middle of the email body but can't work out how? Does anyone know? Sub SendEmails() Dim Emails, Subject, FName, SName, Attachment, Body As String Dim i As Long Dim OutApp As Object...

Hello, I have a set of websites listed in an excel sheet, I tried to extract hyperlink using VBA code (I found it online), but I find out that they not clickable. Could you edit it or give another trick to fix this problem, please? Sub ExtractHL() Dim HL As Hyperlink For Each HL In...

Hello, I have a set of facebook profiles listed in my Excel spreadsheet, the thing is that when I click on any profile, it opens up with both mobile version and the web version. I need to stop the mobile version so that when I click on the profile it only open the web version. P.S : I tried...

Hello, I have two sheets, first of them has a data table with the income of a list of 14 companies during 2018 and 2019. The other sheet I've a data table with a list of these companies and next to the name an hiperlink. When it's selected, it transports you to the cell located in the row of...

Hello, I am trying to hyperlink a file. The first part of the filename is constant but the end has a variable date. Is there a way to look at the constant portion only when referencing? For example the file's name is: "EarningsDiscrepancy_0069_2021_20220429_093447_5649" I would like for it to...

Hello there, I have a simple Hyperlink formula: =HYPERLINK("#Index!A7","Link") How can I make the sheet name and the cell dynamic?. Something like: Sheets("Summary").Cells(lastrow + 1, 8).Value = "=HYPERLINK(""#ActiveWorkbook.Worksheets(i).Name ! ActiveWorkbook.Worksheets(I).Cells(j...

Hi team, I am looking to have a column of hyperlinks (in say Row B), and have Column A be the cells that have the firendly name, which will be pulled from a list on a different sheet. EG: Cell A1=Data validation value. of "In Progress" and "Done" (The text here is not important, I...

Hi All, I need some help please and I can't seem to find any guides that cover this, so apologies if this is very novice. I have a drop down box and I am trying to get it to generate a hyperlink in the cell next to it, but assign a name (i.e. if url is www.google.com, give me a link that is...

Hello All, I am seeing some peculiar behave and I assume someone has seen this. I have and Excel spreadsheet (call it Summary.xlsx) on a company network drive (call it \\networkdrive\fold1\fold2). In a cell I create a hyperlink to a PDF file using \\networkdrive\fold1\fold2\fold3\file.xlsx...

Greetings all, I'm relatively new to VBA and I would like some help on a problem I'm trying to solve for. I have two columns of data and both of them are text initially. I first ran the VBA below to turn texts in the "Hyperlink" column into clickable links. However, I would also like them to...

Hello guys, I have an excel sheet in which I have many hyperlink. All hyperlinks have separate PDF files I want to print that PDF file when I click on hyperlink without opening it. Please help me with this.

Hi, I'm basically looking for a method to merged all filtered .pdfs based on "work pack" column into one pdf using the button shown, see image attached. Is this even possible? I've seen methods using Acrobat Pro which I do not own. If when I click the button, it generates a merged pdf file...