Dynamic Embedded Hyperlinks?

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

hall.jeff@gmail.com - 30 Nov 2007 15:40 GMT

I'm creating a spreadsheet for clients to use to go out and hit a
government website to get data. Every client has a different
Certificate Number to get their information from. I'd like to give the
client a box to input their CERT number so that I don't have to worry
about customizing everyone's sheet for them... Is there any way to do
this? I'll setup some VBA code that looks for updates of that one cell
if I have to... but I was hoping there was just some way to make the
address referenced in the link reference back to a cell in excel?

Reply to this Message

Don Guillett - 30 Nov 2007 15:57 GMT

You give no example but try a formula for an existing hyperlink
="partof" & a2 & "restof"

Signature

Don Guillett
Microsoft MVP Excel
SalesAid Software
dguillett1@austin.rr.com

> I'm creating a spreadsheet for clients to use to go out and hit a
> government website to get data. Every client has a different
[quoted text clipped - 4 lines]
> if I have to... but I was hoping there was just some way to make the
> address referenced in the link reference back to a cell in excel?

Reply to this Message

Peo Sjoblom - 30 Nov 2007 16:05 GMT

Have you looked at the HYPERLINK function? You can use the cell content to
get a hyperlink. What you could do would be to use an IF function with a
HYPERLINK and testing for instance

IF(A1 = "", "", HYPERLINK(xxxxx&A1))

I find the HYPERLINK function quite handy at times, more so than the
hardcoded insert>hyperlink one

Signature

Regards,

Peo Sjoblom

Reply to this Message

hall.jeff@gmail.com - 30 Nov 2007 17:56 GMT

didn't even occur to me to link to see if there was a function...
You're right, that's much, much more useful...

Reply to this Message

Rate this thread: