Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Custom Hyperlink
I would like to have a hyperlink that changes depending on what text is in a
cell. If cell A1 says 1234, the hyperlink would be: \\Common\Engineering\SPO-SPP\SPO-1234 If cell A1 says 2468, the hyperlink would be: \\Common\Engineering\SPO-SPP\SPO-2468 How do I get cell A1 into the hyperlink? -- Brian H |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Custom Hyperlink
Use the HYPERLINK function for this, there is ample info in help for this
function -- Regards, Peo Sjoblom "Brian H" wrote in message ... I would like to have a hyperlink that changes depending on what text is in a cell. If cell A1 says 1234, the hyperlink would be: \\Common\Engineering\SPO-SPP\SPO-1234 If cell A1 says 2468, the hyperlink would be: \\Common\Engineering\SPO-SPP\SPO-2468 How do I get cell A1 into the hyperlink? -- Brian H |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Custom Hyperlink
Thanks.
I wasn't having luck with that but finally figured it out. The part I was missing was ............"&A1 =HYPERLINK("\\Common\Engineering\SPO-SPP\SPO-"&A1,A1) -- Brian H "Peo Sjoblom" wrote: Use the HYPERLINK function for this, there is ample info in help for this function -- Regards, Peo Sjoblom "Brian H" wrote in message ... I would like to have a hyperlink that changes depending on what text is in a cell. If cell A1 says 1234, the hyperlink would be: \\Common\Engineering\SPO-SPP\SPO-1234 If cell A1 says 2468, the hyperlink would be: \\Common\Engineering\SPO-SPP\SPO-2468 How do I get cell A1 into the hyperlink? -- Brian H |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
custom toolbar item to use hyperlink to open word file | Excel Discussion (Misc queries) | |||
Can't make hyperlink function work for hyperlink to website | Excel Worksheet Functions | |||
Moving rows with Hyperlink doesn't move hyperlink address | Excel Discussion (Misc queries) | |||
Can you link a custom property to an Excel custom header text? | Setting up and Configuration of Excel | |||
Intra-workbook hyperlink: macro/function to return to hyperlink ce | Excel Discussion (Misc queries) |