You may be able to use data|validation and dependent lists.
Debra Dalgleish knows how:
http://contextures.com/xlDataVal02.html
Emea training wrote:
Hi,
I want to have a list (ok with that bit) which is actually dynamic
depending on the value in a certain cell. Ie: if you are in department
x, the list will only show codes appliacble to deprtament X, whereas if
you enter department Y - a different list appears.
I know how to do the lists and look ups but it is the dynamic lists bit
that I am stuck with.
Does anyone have any idea?
--
Emea training
------------------------------------------------------------------------
Emea training's Profile: http://www.excelforum.com/member.php...o&userid=12064
View this thread: http://www.excelforum.com/showthread...hreadid=558470
--
Dave Peterson