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

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

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