Dynamic drop-down menus with PivotCharts

  • Thread starter Thread starter Josip.2000
  • Start date Start date
J

Josip.2000

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
 
Hi,

The answer is yes, but the problem is how do you decide what items to show
in the second drop down when there are 50 possible lists?

One why, using data validation list for your drop down is to attach code to
the worksheet_change event which responds to a change in the data validation
cell by choosing from one of the 50 lists for Y.

So we are back to the first question.
 
Back
Top