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