Quote:
Originally Posted by lisalou24
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.