For a solution that works with data organized in a relational data
format see
Cascading queries
http://www.tushar-mehta.com/excel/ne...wns/index.html


On Tue, 19 Aug 2008 08:03:01 -0700, Lisa
wrote:

Josip,
Did you get this figured out? I'm trying to do the same thing with 5
drop-downs connected to one another. Any advice or examples would be
helpful.

Thanks,
Lisa

" wrote:

Hi!

The data I have can be categorized for example in two categories;
category X and Y (+ time)
The problem however is that I would like to have some kind of dynamic
drop-down menu for my second option (category Y) which changes based
on the choice of X.

The problem is that right now, I have 20 X items, but let's say 1000 Y
items, so to go through the whole list of 1000 is a bit tedious when
making selections. So I was thinking, that a much more elegant
solution would be to have the content of the Y menu change based on my
choice of X, thus narrowing the list to about 50 (if the Y's are
evenly distributed/connected to the different X's)

To me it sounds like a simple piece of code, but can it be done?
Examples?

BR,
Josip


Regards,

Tushar Mehta
Microsoft MVP Excel 2000-2008
www.tushar-mehta.com
Tutorials and add-ins for Excel, PowerPoint, and other products