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