A folder contains 1100 excel workbooks of clients named based on their
account numbers.
A main file contains this

54625 hyperlink to D:\accounts\54625.xls
74351 hyperlink to D:\accounts\74351.xls
and so on...

I need a cell where i can simply enter 54325, and i should get a hyperlink
to D:\accounts\54325.xls in the next cell.
I tried using D:\accounts\ & 54325 & .xls and all, but that does not work..

Any other way to do this?
Thanks.

trythis
in B1 type
="D:\accounts\"&A1&".xls"
(note apostrophes)
mow if you ener in A1
54625
B1 will be corresponding vlaue
now insert(menubar)-hyperling
in the <insert-hyperlink window choose
Place in this document
choose the correct sheet
and enter B1
<type cell reference

click ok

B1 will become hyperlink(blue color)
as you change A1 the hyperlink changes

is this what youwant.
if so modify as you require


Nimit Mehta wrote in message
...
A folder contains 1100 excel workbooks of clients named based on their
account numbers.
A main file contains this

54625 hyperlink to D:\accounts\54625.xls
74351 hyperlink to D:\accounts\74351.xls
and so on...

I need a cell where i can simply enter 54325, and i should get a hyperlink
to D:\accounts\54325.xls in the next cell.
I tried using D:\accounts\ & 54325 & .xls and all, but that does not
work..

Any other way to do this?
Thanks.

So i will have to use as a helper coloumn. And in C1 i can use =hyperlink(B1).
Working fine..
Thanks..

"R.VENKATARAMAN" wrote:

trythis
in B1 type
="D:\accounts\"&A1&".xls"
(note apostrophes)
mow if you ener in A1
54625
B1 will be corresponding vlaue
now insert(menubar)-hyperling
in the <insert-hyperlink window choose
Place in this document
choose the correct sheet
and enter B1
<type cell reference

click ok

B1 will become hyperlink(blue color)
as you change A1 the hyperlink changes

is this what youwant.
if so modify as you require


Nimit Mehta wrote in message
...
A folder contains 1100 excel workbooks of clients named based on their
account numbers.
A main file contains this

54625 hyperlink to D:\accounts\54625.xls
74351 hyperlink to D:\accounts\74351.xls
and so on...

I need a cell where i can simply enter 54325, and i should get a hyperlink
to D:\accounts\54325.xls in the next cell.
I tried using D:\accounts\ & 54325 & .xls and all, but that does not
work..

Any other way to do this?
Thanks.