Hi,

I have a created a dashboard, without using any macros. All the
dynamism in the dash-board is done using formulae. I have two
drop-downs, which are cascaded, and which control the display of the
data in the dashboards.

The issue here is : I need to re-set or "clear" the data in the second
drop down, whenever the data in the first drop -down is changed. I did
manage to rummage through some of the older posts in the group, but
most of them employ macros, which i dont want to employ here.
Can this be done using formulae?

Thanks in Advance,
Sagar

Hi!

What exactly does this mean: "whenever the data in the first drop -down is
changed."

Whenever a different selection is made? If that's the case I'm pretty sure
you'd need some code to do what you want.

Biff

"Sagu" wrote in message
ups.com...
Hi,

I have a created a dashboard, without using any macros. All the
dynamism in the dash-board is done using formulae. I have two
drop-downs, which are cascaded, and which control the display of the
data in the dashboards.

The issue here is : I need to re-set or "clear" the data in the second
drop down, whenever the data in the first drop -down is changed. I did
manage to rummage through some of the older posts in the group, but
most of them employ macros, which i dont want to employ here.
Can this be done using formulae?

Thanks in Advance,
Sagar

do you mean the second dropdown selections are supposed to change with a new
choice in the first but dont?Or you dont know how to make the second drop
down dependent on the first?What sort of dropdowns sre you using.

http://www.contextures.com/xlDataVal02.html
--
paul
remove nospam for email addy!



"Biff" wrote:

Hi!

What exactly does this mean: "whenever the data in the first drop -down is
changed."

Whenever a different selection is made? If that's the case I'm pretty sure
you'd need some code to do what you want.

Biff

"Sagu" wrote in message
ups.com...
Hi,

I have a created a dashboard, without using any macros. All the
dynamism in the dash-board is done using formulae. I have two
drop-downs, which are cascaded, and which control the display of the
data in the dashboards.

The issue here is : I need to re-set or "clear" the data in the second
drop down, whenever the data in the first drop -down is changed. I did
manage to rummage through some of the older posts in the group, but
most of them employ macros, which i dont want to employ here.
Can this be done using formulae?

Thanks in Advance,
Sagar

Hello folks,

Thanks for replying to my query.

The scenario is i have created drop downs using Ranges and Validation.

The first drop down contains a Named range
The second drop down is populated by using a IF condition within the
Validation Settings and hence depending upon the selection in the first
drop down list, the second drop down is populated.

The Issue here being, the cell containing the second drop down list
"retains" the value of the previous selection.

For example :

Drop down list in Cell A1 lists all the Categories.

Drop down list in Cell B2 lists all the products.

For the first time, the selection in the Cell A1 (Categories) populates
the data in the drop down list of the Cell B2 ( Products)

From the Second time, if the selection in the Cell A1 Changes, the drop
down list populating the Cell B2 changes, but NOT the content of cell
B2,which retains the value of the previous selection . I need to clear
the value present in the cell B2 ( which is a value from the previous
selection)

Hope i am clear in conveying my requirements.

Please let me know if there any issues, else i can send the excel file
across..

Thanks once again for spending your time on this..
Sagar

Hi!

To do EXACTLY what you want will require VBA code. I can't help you with
that.

An alternative to code would be to use conditional formatting to set the
cell font color to be the same as the fill color if the value in the cell is
not part of the named range that is currently selected from the first drop
down.

That will achieve the effect you're after of "clearing" (or at least,
appearing to be clear) the cell but if you have other formulas that are
dependent upon this cell it may make things more complicated to deal with.

Biff

"Sagu" wrote in message
oups.com...
Hello folks,

Thanks for replying to my query.

The scenario is i have created drop downs using Ranges and Validation.

The first drop down contains a Named range
The second drop down is populated by using a IF condition within the
Validation Settings and hence depending upon the selection in the first
drop down list, the second drop down is populated.

The Issue here being, the cell containing the second drop down list
"retains" the value of the previous selection.

For example :

Drop down list in Cell A1 lists all the Categories.

Drop down list in Cell B2 lists all the products.

For the first time, the selection in the Cell A1 (Categories) populates
the data in the drop down list of the Cell B2 ( Products)

From the Second time, if the selection in the Cell A1 Changes, the drop
down list populating the Cell B2 changes, but NOT the content of cell
B2,which retains the value of the previous selection . I need to clear
the value present in the cell B2 ( which is a value from the previous
selection)

Hope i am clear in conveying my requirements.

Please let me know if there any issues, else i can send the excel file
across..

Thanks once again for spending your time on this..
Sagar