auto scrol doune for hyperlink.

[rajaiy]

Dears,

I have one excel sheet, I need to make auto scrol doun fore the hyperlink,
like this example,

a1 = 419 b1= \\appserver\users\FILE 02-\419.xls.

so how I can make auto hyperlink as the next cell will call the next file no
150 from the same folder as .

a2 = 420 b2= \\appserver\users\FILE 02-\420.xls.
and go on.

Thanks for help...

 

[Jacob Skaria]

In B1
=HYPERLINK("\\appserver\users\FILE 02-\" & A1 & ".xls")
(and copy down as required)

If this post helps click Yes

 

[Dave Peterson]

I'd try:
=hyperlink("http:////appserver\users\FILE 02-\"&a1&".xls","Clickme")

or maybe if that number had to be formatted nicely:
=hyperlink("http:////appserver\users\FILE 02-\"&text(a1,"000")&".xls","Clickme")