External link
 

I want to do this:

In a call in a worksheet (destination) I want to have a hyperlink to another
Excel worksheet (source).

In a cell in the worksheet (source) that is represented by the hyperlink I
want to pick a cell with a number which is automatically shown in a cell on
the destionation worksheet. The cell in the source worksheet will have a
name for easier reference.

Anybody has an idea how this could be done?

thx for your answers!

from help...
HYPERLINK(link_location,friendly_name)

Link_location is the path and file name to the document to be opened as
text. Link_location can refer to a place in a document€” such as a specific
cell or named range in an Excel worksheet or workbook, or to a bookmark in a
Microsoft Word document. The path can be to a file stored on a hard disk
drive, or the path can be a universal naming convention (UNC) path on a
server (in Microsoft Excel for Windows) or a Uniform Resource Locator (URL
(Uniform Resource Locator (URL): An address that specifies a protocol (such
as HTTP or FTP) and a location of an object, document, World Wide Web page,
or other destination on the Internet or an intranet, for example:
http://www.microsoft.com/.)) path on the Internet or an intranet.

Link_location can be a text string enclosed in quotation marks or a cell
that contains the link as a text string.

If the jump specified in link_location does not exist or cannot be
navigated, an error appears when you click the cell.

Friendly_name is the jump text or numeric value that is displayed in the
cell. Friendly_name is displayed in blue and is underlined. If friendly_name
is omitted, the cell displays the link_location as the jump text.

Friendly_name can be a value, a text string, a name, or a cell that contains
the jump text or value.

If friendly_name returns an error value (for example, #VALUE!), the cell
displays the error instead of the jump text.


In Excel for Windows, the following example displays the contents of cell D5
as the jump text in the cell and opens the file named 1stqtr.xls, which is
stored on the server named FINANCE in the Statements share. This example uses
a UNC path:

=HYPERLINK("\\FINANCE\Statements\1stqtr.xls", D5)

The following example opens the file 1stqtr.xls in Excel for Windows that is
stored in a directory named Finance on drive D, and displays the numeric
value stored in cell H10:

=HYPERLINK("D:\FINANCE\1stqtr.xls", H10)

In Excel for Windows, the following example creates a hyperlink to the area
named Totals in another (external) workbook, Mybook.xls:

=HYPERLINK("[C:\My Documents\Mybook.xls]Totals")



--
paul
remove nospam for email addy!



"KIS" wrote:

I want to do this:

In a call in a worksheet (destination) I want to have a hyperlink to another
Excel worksheet (source).

In a cell in the worksheet (source) that is represented by the hyperlink I
want to pick a cell with a number which is automatically shown in a cell on
the destionation worksheet. The cell in the source worksheet will have a
name for easier reference.

Anybody has an idea how this could be done?

thx for your answers!