hyperlink

Any all all help is appreciated! I’m operating out of a company SharePoint, as multiple people need to be able to access these sheets. I want to have a Master sheet, that tracks information from ~300 individual site portfolios. I want the Master sheet to be able to automatically pull about 30+...

Hi to all I need some help with hyperlink that should point to specific cell in another sheet In Sheet1 I have a row with dates like you can see in the picture: It start from first week of year in A2 (31/12-06/01/2024) and finish in FI2 In Sheet2 I use this formula to jump to a specific...

I wanted to create hyperlinks to open PDF files, based on the full filepath. See example below. Is there a way to turn this formula into a link that shows "Myfile.pdf" at the end ... in one step to prevent copy and paste, and then double clicking each cell to turn into a link ... without VBA...

Hi colleagues, I'm having lil bit issue with my Filter formula. So, basically I have 1 master data for scoring and in other hand i need to disclose some certain range that meets some condition. Have a look in uploaded pic. On the left table is the master data, on the right I disclosed some...

Hello I have tried using the hyperlink formula to dynamically link to newly created test sheets from a template sheet. Its a basic workbook at this point with the template having name "sheet1", and the subsequent test sheets having names "sheet1 (2)" and so on. I have used the formula...

Morning folks - hope you can help. I'm trying to create a hyperlink that goes to "today's date" when the date rates sits in one row over multiple columns. I've seen some videos on you Tube but the all seem to list dates in rows, I've tweaked the formula but it comes back with "Reference isn't...

Hello All, I was sent a file that I am trying to analyze to be able to modify going forward. This was made at another site by an employee that no longer works there so I have no real reference on how it is supposed to work. The main issue is with the Hyperlink function and potentially using...

Hi, I have created a "Table of Contents" sheet in my report which has hyperlinks to other sheets. I have used hyperlink formula to navigate to different sheets. This works fine in excel. However, when the excel is printed in pdf, the hyperlinks are non-clickable. Can anyone please help resolve...

I have a spreadsheet with multiple tabs. I am using one tab 'Integration Details' as an at a glance for source information. I am using multiple other tabs, all split by date, to show sessions on those dates will more information including invitees. I want to be able to click on a 'Session Name'...

I have a spreadsheet with a number of hyperlinks (to files on my network drive) that have been created by concatenating fields. The hyperlinks are active & work as intended in the excel sheet. When I convert to pdf they become flat text. How can I convert to pdf or even a word document with the...

I have a master sheet which has hyperlinks. I am copying these cells to smaller sheets, which are duplicated. Ideally I will update the master with the link and all of the smaller sheets will then have that link, unfortunately the links do not work in any of the smaller sheets. I am using the...

Okay, I have several tables on several worksheets. I have another table that lists all the formulas from the other tables, so that if I ever get hit by a bus, and someone wipes out the original formula in the other table, they can find it here. I am only using formulas in this spreadsheet, as...

Hello, I'm looking for a way to take the contents of a cell and convert it to a custom hyperlink when a cell change is detected. I'm currently using a drop-down list in one column, and another to build the custom URL using that drop-down list selection. Here's what I'm using currently to only...

I have a shared excel workbook within my team and within the workbook are embedded hyperlinks to other shared excel workbooks. For all of the team apart from one, the hyperlink opens the excel workbook, but for one colleague the hyperlink downloads. I have scoured her settings but can't see...

Hi I just noticed that Excel hyperlink won't be able to open a file that has pound sign (Hash #) in the file name. One solution is to rename those files. However, I have so many files with (#) in their name which not possible solution. Any thought on how to solve this issue?

Hi MrExcel community, this is my first time for posting here. Though I know the topic about matching(look up) and hyperlinks in VBA Excel has been repeated a lot. I have a macros that I would love to ask on how to code which I will explain the criteria of it down below with a picture for better...

I have a piece of code used to on a button to grab an excel file, copy a few bits of data from it, and paste to my current open file and sheet to particular cells. How do I take the path of the selected file and paste it as a link in my currently open workbook and sheet in cell A35. I just...

I have the following code that creates hyperlinks from all pdfs contained in a folder and listed in column N. Sub extractfiles_hyperlink() Dim xFSO As Object Dim xFolder As Object Dim xFile As Object Dim xFiDialog As FileDialog Dim xPath As String Dim i As Integer...

I have a list of members in column A with their website URL (just url) listed in column B, I copy the URL of each member from the column B into hyperlink in column A, and this process takes a long time. I need a macro code to do it for all the members.

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