RE: Dynamic drop-down menus with PivotCharts

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

Shane,
Great! Any help would be appreciated. I don't see your example file in
your post, do I have to go some where else to get it?

Lisa

"ShaneDevenshire" wrote:

Hi,

I am sending a file with an example. Note the range names and the data
validations in columns A and B.
--
Thanks,
Shane Devenshire


"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

"Josip.2000@xxxxxxxxx" 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

.

Relevant Pages

  • RE: Discussion group problem - my computer?
    ... "ShaneDevenshire" wrote: ... "Read and rate the response" it takes me to ... Shane Devenshire ... I hit Cancel or Continue, two options that show up and the ...
    (microsoft.public.excel.misc)
  • Re: Find the row number of name occurence
    ... On 2 Oct, 05:57, ShaneDevenshire ... can hide 0's by choosing Tools, Option, View and unchecking Zero values or ... Shane Devenshire ... occur in (each name will occur a maximim of 7 times, ...
    (microsoft.public.excel.worksheet.functions)
  • Re: paste into multiple columns
    ... On Nov 10, 5:29 pm, ShaneDevenshire ... Columns command once on the entire column. ... Shane Devenshire ... if there is a quick and dirty trick for this (ideally w/o invoking ...
    (microsoft.public.excel)
  • RE: countif
    ... "ShaneDevenshire" wrote: ... Shane Devenshire ... specifically want to know how often the value in the row of cells is>=25. ... E37 that varies according to the number I want to test for in the row as ...
    (microsoft.public.excel.misc)