Hyperlink.

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
So i will have to use as a helper coloumn. And in C1 i can use =hyperlink(B1).
Working fine..
Thanks..
 
Back
Top