| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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... |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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... |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do I creat scrol Bar in cell? | Excel Discussion (Misc queries) | |||
| Auto-Hyperlink | Excel Discussion (Misc queries) | |||
| excel sheet and word doc. how can I compare both simult and scrol | Excel Discussion (Misc queries) | |||
| how do I make a heading row "float" to follow the data as I scrol. | Excel Worksheet Functions | |||
| Calculating negative time & creating scrol bars for fixed size txt box. | Excel Discussion (Misc queries) | |||
Linear Mode
