Clearing the Values in a Drop - Down List

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

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
>
>

Hello Martin...

Yes, i am populating the drop down using ranges and data validation.
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