Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
hyperlink help
I have this
\\Pwreports\PWREPORTS\2010\197\2010000005_NIBRS Incident Report.pdf I can make the hyper link work once, ( flashes real fast and disappears) I need change two things the 197 and 2001000005 The 197 is the ofc badge and is located in cell bh6 and the 2010000005 is the case number and is located in cell au6 but when i change it to the cells in which the info is it doesn't work no more The link refers to a drive in which the ofc's report is located , its under year\ofc badge number\case number underscoreNIBRS Incident Report.pdf |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
hyperlink help
Try this formula:
=HYPERLINK("\\Pwreports\PWREPORTS\2010\"&BH6&"\"&A U6&"_NIBRS Incident Report.pdf","Open PDF") Hope this helps. Pete On Apr 9, 1:53*am, Shawn wrote: I have this \\Pwreports\PWREPORTS\2010\197\2010000005_NIBRS Incident Report.pdf I can make the hyper link work once, ( flashes real fast and disappears) I need change two things *the 197 and 2001000005 The 197 is the ofc badge and is located in cell bh6 and the 2010000005 is the case number and is located in cell au6 *but when i change it to the cells in which the info is it doesn't work no more * The link refers to a drive in which the ofc's report is located , its under year\ofc badge number\case number underscoreNIBRS Incident Report.pdf |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
hyperlink help
Check one of your other posts.
Shawn wrote: I have this \\Pwreports\PWREPORTS\2010\197\2010000005_NIBRS Incident Report.pdf I can make the hyper link work once, ( flashes real fast and disappears) I need change two things the 197 and 2001000005 The 197 is the ofc badge and is located in cell bh6 and the 2010000005 is the case number and is located in cell au6 but when i change it to the cells in which the info is it doesn't work no more The link refers to a drive in which the ofc's report is located , its under year\ofc badge number\case number underscoreNIBRS Incident Report.pdf -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Paste Hyperlink result as working hyperlink | Excel Worksheet Functions | |||
Can't make hyperlink function work for hyperlink to website | Excel Worksheet Functions | |||
How do I create a hyperlink to a cell with the hyperlink function | Excel Worksheet Functions | |||
Moving rows with Hyperlink doesn't move hyperlink address | Excel Discussion (Misc queries) | |||
Intra-workbook hyperlink: macro/function to return to hyperlink ce | Excel Discussion (Misc queries) |