Dynamic Embedded Hyperlinks?

  • Thread starter Thread starter hall.jeff
  • Start date Start date
H

hall.jeff

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?
 
You give no example but try a formula for an existing hyperlink
="partof" & a2 & "restof"
 
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


--


Regards,


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