How do I link 4 columns to each other

[B's Space]

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 .

[Toppers]

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 .

[B''s Space]

Hi Toppers

Oops, yes I think i did not make it clear enough. Sorry 'bout that. I am
currently sitting with a worksheet of about 30 columns. The problem is, all
of these columns are sort of linked to each other. Meaning, 8 columns have
Personal Details Split up, whereas, if I can put it all into one column and
have sort of a heading and a sub-heading. Hmmmmm... I am not sure if you
would understand what I want. I know what I want but I am finding it
difficult to explain in Words.
Trying again!
Column 1 should have Name and Surname
Column 2 Personal Details (Age, Address, ID Nr, Gender, Race, etc)
Column 3 Training (X, Y, Z Results)
Column 4 Test (1,2,3,4,)

If I example select the name Jenny Jacobs in column 1, then column 2,3 & 4
must automatically reflect all details linked to Jenny.
Hope this makes sense?
I am trying a PIVOT and hope there is an easir option. Is there?????

Thanks
B's Space

"Toppers" wrote:

> 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 .

[hardyz2]

Hi mate,

Sorry to jump on your thread but I am after the same thing.
Basically I run a Fantasy football league and have a spreadsheet for people to choose there teams.
When they select a player from a list in column A (player name) I would like their club and value to appear in columns B & C without them having to select them separately

Example:
Cech - Chelsea - 4.8 (when they select Cech, Chelsea & 4.8 appear in cells B & C)

Thanks to anyone that can help.

[B''s Space]

Hi hardy

Yes, that is exactly what I want... Hope someone out there can come to our
rescue.
Thanks for making it clearer.

B's Space

"hardyz2" wrote:

>
> Hi mate,
>
> Sorry to jump on your thread but I am after the same thing.
> Basically I run a Fantasy football league and have a spreadsheet for
> people to choose there teams.
> When they select a player from a list in column A (player name) I would
> like their club and value to appear in columns B & C without them having
> to select them separately
>
> Example:
> Cech - Chelsea - 4.8 (when they select Cech, Chelsea & 4.8 appear in
> cells B & C)
>
> Thanks to anyone that can help.
>
>
> --
> hardyz2
> ------------------------------------------------------------------------
> hardyz2's Profile: http://www.excelforum.com/member.php...o&userid=36534
> View this thread: http://www.excelforum.com/showthread...hreadid=562807
>
>

[Gord Dibben]

I will point you to a valuable source of assistance on the VLOOKUP function and
examples of its use.

Debra Dalgleish has instructions, examples and downloadable workbook.

http://www.contextures.on.ca/xlFunctions02.html

You may also want to explore the use of Data Validation drop-down list to pick
your item from.

http://www.contextures.on.ca/xlDataVal01.html



Gord Dibben MS Excel MVP


On Wed, 19 Jul 2006 08:06:02 -0700, B''s Space
<[email protected]> wrote:

>Hi hardy
>
>Yes, that is exactly what I want... Hope someone out there can come to our
>rescue.
>Thanks for making it clearer.
>
>B's Space
>
>"hardyz2" wrote:
>
>>
>> Hi mate,
>>
>> Sorry to jump on your thread but I am after the same thing.
>> Basically I run a Fantasy football league and have a spreadsheet for
>> people to choose there teams.
>> When they select a player from a list in column A (player name) I would
>> like their club and value to appear in columns B & C without them having
>> to select them separately
>>
>> Example:
>> Cech - Chelsea - 4.8 (when they select Cech, Chelsea & 4.8 appear in
>> cells B & C)
>>
>> Thanks to anyone that can help.
>>
>>
>> --
>> hardyz2
>> ------------------------------------------------------------------------
>> hardyz2's Profile: http://www.excelforum.com/member.php...o&userid=36534
>> View this thread: http://www.excelforum.com/showthread...hreadid=562807
>>
>>