auto scrol doune for hyperlink.
 

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...

auto scrol doune for hyperlink.
 

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

If this post helps click Yes
---------------
Jacob Skaria


"rajaiy" wrote:

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...

auto scrol doune for hyperlink.
 

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")

rajaiy wrote:

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...

--

Dave Peterson