dynamic hyperlink

Hello, Am new here and I don't know if I should create a new thread but my question is related to dynamic hyperlinks. Anyways, I created a dynamic hyperlink that can jump to desired sheet based on the sheet name. It works fine. The issue is that the dynamic hyperlink won't work if sheet are...

Hi, Can anyone help with this: Data range: Range (A2) to last row in column G Worksheets: Main - SUMMARY (column H is where i'll put hyperlink - with header) Other worksheets Criteria for address: 1. column I (my helper column) of SUMMARY equals Worksheet name (select) 2. Value in column A...

I'm stuck in how to replace a term with the appropriate VBA code. The goal is to have a dynamic hyperlink that changes not only anchor but also the Display Text. I realize the code as it stands is circular, but I can figure out how to make it work if I could only get the syntax correct...

Hi I've spent 2 days searching around forums to solve my problem and seem to be hitting a dead end, if anyone knows if this is possible or how to do it that's much appreciated. I'm trying to send emails based on this link Mail a different file(s) to each person in a range Col A is name, Col B...

Forgive me if this has already been asked, but I could not find an answer. I found many threads on Dynamic Hyperlinks, but not ones with this issue. I'm hopeful this has a simple solution. I need to create a dynamic hyperlink. Sheet 1 Column A1 = 3/0/1 Column A2 = 3/0/2 Sheet 2 Column C3 =...

Hi, This is my first post. I am normally a bit of a lurker. I tried for about 4 hours to work this out yesterday and few hours today on this one. I am using Excel 2010 and Windows 7 64bit. I am using an excel workbook that is updated and changed constantly, Rows are added daily, columns...

Hello to all visitors of this post, I'm trying to compile some data to help out myself and fellow co-workers. I'm not an expert in excel by any means but here is what I have so far. I have multiple sheets (about 70 in all) that have data of customers that show pricing, quantity, and total...

Setup:OS: WinXP with latest service pack XL: 2010 version IE: v8.0.6 Problem: I have a spreadsheet that I need to insert nations' flags into individual cells. I would like to do this using URLs for each nation in cells adjacent to where the flags will be. The URLs are of certain...

I took a look around and noticed I can use the HYPERLINK command to link to a URL plus the contents of a different cell, such as something like =HYPERLINK(www.blah.com&A1). My question is, can I do a dynamic hyperlink that is smart enough to append whatever data is in the same cell to be the...