Hello, the text below describes my problem:
Take, as an example, a sheet with two columns labeled 'First' and Second'.
Both columns have three rows containing numbers 1, 2, 3:
First | Second
1 | 1
2 | 2
3 | 3
- Activate autofilter on the column headers.
- For column 'First' select '1' from the autofilter dropdown list. Now
only
one row is displayed in the sheet: 1 | 1
- Examine the autofilter dropdown list for column 'Second'. Notice that
all
three values (1, 2, 3) are displayed, even though, logically, there is only
one row in the active result set and only one possible choice for the
value of
column 'Second' (the value 1) given the active filtering on column
'First'.
Selecting anything other than the value '1' in the second column
dropdown list
results in a null result (no matching rows).
In Excel, autofilter dropdown lists only show the possible values based on
already-active filtering, so that it is not possible to return a null set.
For example, in the above demonstration, clicking on the 'Second' column
autofilter dropdown arrow would present a list with only one item: '1'. In
other words, Excel bases its autofiltering on the active result set, not
the
original dataset/table.
Ok, I really need this active behavior, so there's some way of create
this effect? By scripts or something??
Thanks in advance.
_______________________________________________________
Yahoo! Acesso Grátis - Internet rápida e grátis.
Instale o discador agora! http://br.acesso.yahoo.com/
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
