hyperlink construction

  1. L

    VBA Macro Create Hyperlink out of Cell Value contents

    Hello All, I'm trying to create a series of Macros that take the contents of Column E, puts a direct hyperlink to website in question. I just can't seem to find the code online to help me achieve what I want. This is the code I have so far. Dim sh1 As Worksheet Dim...
  2. M

    Conditional hyperlink onto a shape

    Hello all, I have a project I've been working on and up till this point I've been using shapes to link to other sheets within the workbook. However, I would like to add a new "current stage" button that will send me to a specific sheet depending on the value in cell A5 in Sheet1. I'm pretty...
  3. S

    Opening multiple Hyperlinks from a table containing hyperlink data tags

    Hi all, I am new to the forum. I am writing a sheet (link sheet) that includes a number of Hyperlinks (6-700) and I am including tags against each hyperlink; some of the hyperlinks will have more than one tag. I want to create one hyperlink on another sheet (master sheet) in the same workbook...
  4. B

    Excel data to Google Map Location

    Hi,Im new here but I have a minor Excel issue. (I use Excel 2010 for my sins)I have a list of adresess and postcodes in an excel table.Each property has a unique identifier and I currently have a enquiry sheet that runs several Vlookuups and returns all of the site details when a user inputs the...
  5. S

    How to add Hyperlinks of multiple folders to multiple lines of a spreadsheet.

    I work in sales and I have a list of schools that I do business with. In the spreadsheet it has the school name, tel number, postcode address etc. I have notes for each account or line in notepad documents on my PC. I need to be able to link all of the correct notes to the respective...
  6. J

    Hyperlinked Names In DropDown Box

    Hello, I have a spreadsheet with the same dropdown list in each cell of one column. I would like each drop down list to behave in the following manner: When a user selects the appropriate name from the drop down list the name turns into a "blue colored" active hyperlink to an...
  7. M

    text string seach and count???

    Alright i have a term i want to search say "Large Dog" I have a list of about 200 rows of files (located in a few main folders on my computer) that i want to search through each of the text strings. Is there a way that i can search through the entire list and have the formula return return a...
  8. A

    Hyperlinks between two cells

    Hi folks I have two workbooks one which contains a list of experiments and the other which contains the experiment data. I am trying to write a macro that will go through the list in the first book and the experiments in the second and create a hyperlink between a name and the corresponding...
  9. M

    Cell Address in =Hyperlink

    I want to use a cell address as the "link to:", of a =Hyperlink construction. The cell contents are dynamic and must be constructed from a conconacation of two cells. Thanks

Watch MrExcel Video

This Week's Hot Topics

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top