It's not clear to me how you want this to work. Is column 1 cell a Data
Validation, as you say "Click" and select the name and where are the other
details; what you mean by "pop up".

Sorry to be so dim ... but perhaps an sample of data might clarify it (at
least for me!)

"B's Space" wrote:

I want to create multiple cells within a cell. Example,
Column 1: Name and Surname , Column 2: Personal Details, Colums 3:
Training Results, Column 4, Test Results
When I clink on Column 1 and select teh name, I automatically want Column
2,3 & 4 to pop up and show me all relevant details .