Hey there!
I am using Excel 2010 and what I am trying to do *should* be rather simple I think, but I just don't know how to do it.
I have a Workbook with 2 sheets.
Sheet 1 is displaying Names only
Sheet 2 has 4 columns (table); Names, Phone, Address, E-Mail address
What I need Sheet 1 to do is when I double click on any of the names, it opens a new sheet with only that persons name, phone, address, and email address.
Logically I would need to link lets say cell B4 in Sheet 1 to display in a new sheet cells A2, B2, C2, and D2 from Sheet 2.
Thank You
Bookmarks