Sure, if you just want D19 then you can do this:
If you want the flexibility of having different hyperlink for different cells, then you can use the following code instead.
D19 will have a hyperlink to h ttp://server.domain.net/apps/<D19 Value>?OpenDocument
D20 will have a hyperlink to h ttp://anotherdomain.net/ticket=<D20 Value>
D21 and D22 will both use the same hyperlink address of h ttp://yetanotherone.com/value=, then followed by the contents of the appropriate cell.
Hopefully you can see how you can alter this to fit your needs, but if you have any questions feel free to ask ![Smilie](https://www.excelforum.com/images/smilies/smile.gif)
Bookmarks