Displaying Data Based on Selection

[Vance]

This question relates to Excel 2007. I have a worksheet where column A is simply a list of names. Columns B thru G contain confidential data related to those names. I would like to mask or hide the confidential data until a column A cell containing a name is selected and then only display the related data for the selectd row. If someone on the column A list wants to view their confidential data, I don't want anyone elses data displayed. Perhaps there are alternative methods for acheiving this.

Thanks

[martindwilson]

have a look at excels vlookup function and data validation function a combination ot those two will do the job. but i cant see the point coz someone could just choose someone elses name and read the details anyway!

[Vance]

Thanks for the quick reply. I will have a look at these functions. Just to clarify, only one person has access to the data. Others need to be "shown"

[martindwilson]

i havent got 2007 but the principles are the same if you have trouble post back and i/someone will help you with it.