If you're populating your dropdown without macro coding, I guess you must be
setting the input range to a fixed range in your workbook. That means to
clear your dropdown you'll have to clear that particular range or use a
formula (maybe an IF?) that shows nothing for each cell in that range.

"Sagu" wrote:

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