Prev: Alphabetizing
Next: sumif..
From: Shawn on
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

From: Pete_UK on
Try this formula:

=HYPERLINK("\\Pwreports\PWREPORTS\2010\"&BH6&"\"&AU6&"_NIBRS Incident
Report.pdf","Open PDF")

Hope this helps.

Pete

On Apr 9, 1:53 am, Shawn <Sh...(a)discussions.microsoft.com> 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

From: Dave Peterson on
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
 | 
Pages: 1
Prev: Alphabetizing
Next: sumif..