Hi all.

I'm wondering if it possible, and if so, how to make a dropdown menu
in excel that the "source data" switches in reg. to earlier choices.

Example:
Lets say if you have a dropdown menu in the C4 cell where you have to
choose i.e. what department someone should work in and one or more
cells that have detailed information on what equipment that person
should use.
Is it possible to then make the dropdown options change between
different equipment spesifications in reg. to wich department one
choosed?

In advance, thank you.

Check this link for instructions:

'Excel -- Data Validation -- Dependent Lists'
(http://www.contextures.com/xldataval02.html)


--
NBVC

Where there is a will there are many ways.
'The Code Cage' (http;//www.thecodecage.com)
------------------------------------------------------------------------
NBVC's Profile: http://www.thecodecage.com/forumz/member.php?userid=74
View this thread: http://www.thecodecage.com/forumz/sh...d.php?t=113715

Hi,
Look into Debra web it has excellent examples

http://www.contextures.com/xldataval02.html

"Rune" wrote:

Hi all.

I'm wondering if it possible, and if so, how to make a dropdown menu
in excel that the "source data" switches in reg. to earlier choices.

Example:
Lets say if you have a dropdown menu in the C4 cell where you have to
choose i.e. what department someone should work in and one or more
cells that have detailed information on what equipment that person
should use.
Is it possible to then make the dropdown options change between
different equipment spesifications in reg. to wich department one
choosed?

In advance, thank you.

Problem solved, Thank you both :)