hyperlink construction

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

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

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

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

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

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

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

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

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