hyperlink

  1. F

    using Hyperlink function to extract Google kilometers into Excel Spreadsheet automatically

    Dear members of the forum, I'm struggling with a mind-numbing task that needs immediate automation. While we're looking for cheap alternatives to employ for automating kilometer calculation from point A to point B, I thought it's best to inquire the forum what are the possible options to 1)...
  2. L

    Create hyperlink via userform

    Hi all Not sure what is going on with this, I need my code to add a user selected hyperlink through the dialogue box, into a table on a different worksheet. I don't want to overwrite the current cell value with the screen tip either, What it is doing, is adding the root part of the hyperlink...
  3. J

    VBA code to Modify Formula using new External Workbook Hyperlink

    Hi, I have a Workbook that serves as an aggregation of data from several other external workbooks (same file directory). The workbooks being referenced are all uniform, so the specific sheet and cell reference is always the same in a column with the only thing changing being the workbook name...
  4. D

    Hyperlink missing by set number of rows

    I have 2 tables on separate sheets that each has its header starting at row 5. I have a formula that hyperlinks from a cell in one sheet to a corresponding cell in another sheet based on a value in a column on my first sheet. I'm using structured references in my formula which maybe the...
  5. D

    Tex & Hyperlinks Sharing Single Cell?

    Hello, Is there a way for one single cell to share both text and a hyperlink? For example, I want a cell that describes something, and then after the description, I'd like there to be a hyperlink that would access a webpage extending the topic? So the text body is separate from the hyperlink...
  6. T

    How to create a hyperlink on a blank cell in excel

    Is it possible to format a blank cell in excel as a hyperlink for a web page. I need to do a blank cell because the website address will always be different depending upon the account. I want to format cell K3 that is blank as a hyperlink
  7. T

    HYPERLINK formula or link VBA Question

    Right now I have a Hyperlink with multiple CC's that I would like to put in a list on the worksheet for ease of changing addresses. At the moment I have a link and the addresses are Separated in the Subject Field of the Edit Hyperlink dialog window as so; For%20Blank%20Tomorrow&cc=matt...
  8. R

    hyperlink using a cell with a date in it to complete the link url

    hi, so i'd like to include a hyperlink in my file that will take you to a folder. the url is this "\shared folder\08-Aug\main folder" i have the date in cell A1 as "Aug 2019" is there a way i can make a formula that will factor in what the date in cell A1 says? Meaning it extracts the...
  9. G

    Hyperlink to cell in sheet based off of list of values

    Hi, I am tying to find a way to create a hyperlink that goes to a specific cell in my sheet. I want the hyperlink to be dynamic and change based off a data validation list of values. For example: Cell B2 contains my list of values, so in B3 I would like toinput a formula that says when...
  10. W

    excel hyperlink issue

    I created a monster. I have a workbook that isbeing used as an index of all our documents. Each row represents one document and each row is made up of several columns. Each row has a hyperlink that spans the entire number of columns . The hyperlink is to a scanned document on the network. They...
  11. D

    Assign hyperlink to existing shape based on current column

    Hello, I have searched for a long time but have not found a way to do this, either in Excel proper or with VBA. I need a way to construct a hyperlink address dynamically in real time and assign that link to a shape on the worksheet. I have a workbook with links to specific (dated) columns...
  12. D

    Hyperlinking Cells not Working

    Hi!!! I'm working on a data base where I need to link cells to another sheet, but its not working and i keep getting the "Cannot open the specified file" message. Even the simplest way using =HYPERLINK('Other sheet'!A509) When i use de manual option "Ctrl+K" it does work. But I need to link...
  13. D

    Power Query - Hyperlink to file

    I have a power query setup that imports tables from all excel files in a folder. Is it possible to have a column that contains a link to the original excel file? [I have this working in a regular excel table using the hyperlink function (which uses the customer name to get to the correct...
  14. D

    How to click hyperlink on webpage

    Hi, I have managed to get on to a webpage through some basic script. On that webpage there are a number of Hyperlinks. I need to identify the appropriate Hyperlink (in the below case it would be where the 'label' is "S-C-BSS-1" and then click it. Is this doable? If so...how? Element...
  15. 1

    Hyperlink based on 2 cell values

    I have a workbook with multiple sheets, on one sheet I have a column with sheet names and the second with cell address example A2 = CONTROL ROOM AE5 B2= $C$4 How can I create a hyperlink that goes to the value in A2 (sheet name) and B2 (cell). Thanks in advance..
  16. K

    Extracting Multiple Strings in a Cell Based on Criteria

    Hi! So I have a situation, I am currently trying to pull out hyperlinks (that are not linked so they are just text in a cell) from multiple cells that link to a website called jama. They are all contained in a column N and there are some that have one link and then another that contains multiple...
  17. P

    vlookup / hyperlink to e-mail

    Hello, Please could any help on a vlookup issue? i have the following lookup =HYPERLINK(IF(IFERROR(VLOOKUP($C$29,Supplier,11,FALSE),"")=0,"",IFERROR(VLOOKUP($C$29,Supplier,11,FALSE),""))) I have a invoice and when i populate the suppliers details i would like to have a hyperlink to their...
  18. R

    Create Hyperlink in Excel to open Task imported from Outlook

    Hi All. I have some code to import all non-completed tasks from Outlook into a spreadsheet. My plan is to then put these into some kind of Eisenhower matrix to allow better organising of important vs urgent tasks etc. I want each task to be a hyperlink which will then open the task in Outlook...
  19. B

    Excel follow Hyperlink not working

    I have the following code that I need to follow a hyperlink. The problem is G7 is using a formula to get the hyperlink from Vlookup. If I manually type the hyperlink into G7, the below code works, but with the formula in G7 it will not. Thanks in advance for any help. Sub FollowHyperlink()...
  20. K

    If Cell Contains Hyperlink Count

    Hello I am trying to construct a vba macro to count everytime a cell contains a hyperlink in range of data. Currenly having it search the row for a hyperlink and then if it finds a hyperlink it will count and not delete the row, deleting the row if it doesn't contain a row. I am currently having...

Some videos you may like

This Week's Hot Topics

  • populate from drop list with multiple tables
    Hi All, i have a drop list that displays data, what i want is when i select one of those from the list to populate text from different tables on...
  • Find list of words from sheet2 in sheet1 before a comma and extract text vba
    Hi Friends, Trying to find the solution on my task. But did not find suitable one to the need. Here is my query and sample file with details...
  • Dynamic Formula entry - VBA code sought
    Hello, really hope one of you experts can help with this - i've spent hours on this and getting no-where. .I have a set of data (more rows than...
  • Listbox Header
    Have a named range called "AccidentsHeader" Within my code I have: [CODE]Private Sub CommandButton1_Click() ListBox1.RowSource =...
  • Complex Heat Map using conditional formatting
    Good day excel world. I have a concern. Below link have a list of countries that carries each country unique data. [URL...
  • Conditional formatting
    Hi good morning, hope you can help me please, I have cells P4:P54 and if this cell is equal to 1 then i want row O to say "Fully Utilised" and to...
Top