I have (1) workbook with 3 sheets.

If I use column A in sheet 1 to list the following going down the list
like this
(A1)Apple
(A2)Boy
(A3)Charlie
(A4)Dan
(A5)Ed
(A6)Frank
(A7)Ginger

And in Sheet 2, I have the same names again, but use colums B,C,D,E,and
F for other information (address, phone, fax, email and notes)

Is there a way that I can hyperlink Charlie from Sheet 1 (A3) to
Charlie in sheet 3 (Who may now be _*without_going_*_to Sheet 3 to see
what cell each contact name is under?

Sheet 3 is really a Master Contact list with 3,000 names that will be
added to and sheet 1 may only have 30 names total that need linked.
There will be a total of about 10-15 sheets with different names, but
the idea is to add the name to any list and be linked to the master
list of Sheet 2

Thanks all!! Awesome site.......

Tracy


--
mbqc
------------------------------------------------------------------------
mbqc's Profile: http://www.excelforum.com/member.php...o&userid=34207
View this thread: http://www.excelforum.com/showthread...hreadid=574362