Hi

I have set a Data Validation List.

What I want to do is when you choose from the drop down menu, it cell
next to it shows different options.

E.g You chose say manager John Smith in A1 and then B1 has a list to
choose from of his team, but if you choose Paul Brown as manager in A1,
B2 has his team to choose from.

Any help will be much appriated


--
1Tone
------------------------------------------------------------------------
1Tone's Profile: http://www.excelforum.com/member.php...o&userid=35178
View this thread: http://www.excelforum.com/showthread...hreadid=549461

Hi

Tone

u please send me ur email id, I will sen u a excel sheet having so many data
validation examples

thanks



"1Tone" wrote:


Hi

I have set a Data Validation List.

What I want to do is when you choose from the drop down menu, it cell
next to it shows different options.

E.g You chose say manager John Smith in A1 and then B1 has a list to
choose from of his team, but if you choose Paul Brown as manager in A1,
B2 has his team to choose from.

Any help will be much appriated


--
1Tone
------------------------------------------------------------------------
1Tone's Profile: http://www.excelforum.com/member.php...o&userid=35178
View this thread: http://www.excelforum.com/showthread...hreadid=549461

Hi

I have emailed my addresses to you


--
1Tone
------------------------------------------------------------------------
1Tone's Profile: http://www.excelforum.com/member.php...o&userid=35178
View this thread: http://www.excelforum.com/showthread...hreadid=549461

See Debra Dalgleish's site for instructions.....with pictures..........on how to
create dependent lists.

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


Gord Dibben MS Excel MVP

On Wed, 7 Jun 2006 08:42:00 -0500, 1Tone
wrote:


Hi

I have set a Data Validation List.

What I want to do is when you choose from the drop down menu, it cell
next to it shows different options.

E.g You chose say manager John Smith in A1 and then B1 has a list to
choose from of his team, but if you choose Paul Brown as manager in A1,
B2 has his team to choose from.

Any help will be much appriated