View Single Post
  #2   Report Post  
wickedchew wickedchew is offline
Senior Member
 
Location: Philippines
Posts: 161
Default

Quote:
Originally Posted by lisalou24 View Post
Hi

I have created a client spreadsheet and I want to know if I can double-click on a cell to bring up certain information? As I have lots of different departments and client contacts, putting everyones direct numnbers/email addresses would be too large, and too many fields on the spreadsheet.

E.g. click on a client name to bring up contact details such as an email address or telephone number? If so, how do I do this? Semi-novice with excel.

At the moment I have just created comments under the names, so when I hover over the field it brings up a little box. But would wondered if there was any other alternative methods?

Thanks
Lisalou24
Here's a sample that you can do. It uses Data Validation with a little help from the VLOOKUP function.

The first worksheet has all your contact details while the second worksheet pulls the data from the first.
Attached Files
File Type: zip Contacts.zip (10.1 KB, 51 views)
__________________
Asobi Wa Owari Da