View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
68jcode 68jcode is offline
external usenet poster
 
Posts: 6
Default Making a field value append a hyperlink

I have a field called "Case#" used to capture a number that represents a
support case number. Simple enough. I would like to have this field
hyperlinked to a URL string and append the value of the cell contents in
order to link directly to the support case that the number represents. For
example:

Cell A1=6895
The URL string is: https://www.support.acme.com/support...tail.php?call=
I want the case number field to auto hyperlink to:
https://www.support.sepaton.com/supp....php?call=6895

So the value in the case# cell is appended to the URL automatically. Is
this possible without writing code?