M
mbqc
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
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