software

Is it possible to create a link between two work books?

I have prepared a data base workbook with client contact information in
one row and a work book with the clients activities. I would like to
click on a cell (A1) (like a button) at the begining of each client in
the data base that would link me to the client's activity workbook.

EXAMPLE:
DATA BASE WORK BOOK
A1 A2
LINK JOHN DOE

CLICK ON A1(LINK) TAKES YOU TO A CELL IN ACTIVITY WORKBOOK.

Ideas appreciated.

Thank you.
TRAVELERSWAY--
travelersway
------------------------------------------------------------------------
travelersway's Profile: www.excelforum.com/member.php...oamp;userid=17623
View this thread: www.excelforum.com/showthread...hreadid=511334Like a hyperlink???

You can hit insert|hyperlink
and follow those instructions to point to a different workbook

travelersway wrote:
gt;
gt; Is it possible to create a link between two work books?
gt;
gt; I have prepared a data base workbook with client contact information in
gt; one row and a work book with the clients activities. I would like to
gt; click on a cell (A1) (like a button) at the begining of each client in
gt; the data base that would link me to the client's activity workbook.
gt;
gt; EXAMPLE:
gt; DATA BASE WORK BOOK
gt; A1 A2
gt; LINK JOHN DOE
gt;
gt; CLICK ON A1(LINK) TAKES YOU TO A CELL IN ACTIVITY WORKBOOK.
gt;
gt; Ideas appreciated.
gt;
gt; Thank you.
gt; TRAVELERSWAY
gt;
gt; --
gt; travelersway
gt; ------------------------------------------------------------------------
gt; travelersway's Profile: www.excelforum.com/member.php...oamp;userid=17623
gt; View this thread: www.excelforum.com/showthread...hreadid=511334

--

Dave Peterson

You could even use a worksheet formula:

=HYPERLINK(quot;C:\my documents\excel\book1.xls#'sheet 1'!A1quot;)

travelersway wrote:
gt;
gt; Is it possible to create a link between two work books?
gt;
gt; I have prepared a data base workbook with client contact information in
gt; one row and a work book with the clients activities. I would like to
gt; click on a cell (A1) (like a button) at the begining of each client in
gt; the data base that would link me to the client's activity workbook.
gt;
gt; EXAMPLE:
gt; DATA BASE WORK BOOK
gt; A1 A2
gt; LINK JOHN DOE
gt;
gt; CLICK ON A1(LINK) TAKES YOU TO A CELL IN ACTIVITY WORKBOOK.
gt;
gt; Ideas appreciated.
gt;
gt; Thank you.
gt; TRAVELERSWAY
gt;
gt; --
gt; travelersway
gt; ------------------------------------------------------------------------
gt; travelersway's Profile: www.excelforum.com/member.php...oamp;userid=17623
gt; View this thread: www.excelforum.com/showthread...hreadid=511334

--

Dave Peterson