Clearing associated dropdown fields
 

Hello,

I have a spreadsheet with a dropdown list. When a particular item is
selected from the dropdown list, a second field is populated. For instance,
the dropdown menu is in cell A1, if a selection is made then B2 is populated.
My issue is the following: If an item is selected from A1, B2 will be
populated, but if the person changes the item in A1, the previous value
remains in B2. Is it possible to "clear the field once A1 has changed values?
Can I do this w/o VB? Any help would be much appreciated.

thanks,

TC

Clearing associated dropdown fields
 

To control the entries in column A, without programming, you could type NA
in a cell, and name that cell NAList.
Then, in the first column with data validation, Allow: List, and for the
formula enter:

=IF(B2="",Produce,NAList)

If there's an entry in column B, you will only be able to choose N/A in
column A.

"TC" wrote in message
...
Hello,

I have a spreadsheet with a dropdown list. When a particular item is
selected from the dropdown list, a second field is populated. For
instance,
the dropdown menu is in cell A1, if a selection is made then B2 is
populated.
My issue is the following: If an item is selected from A1, B2 will be
populated, but if the person changes the item in A1, the previous value
remains in B2. Is it possible to "clear the field once A1 has changed
values?
Can I do this w/o VB? Any help would be much appreciated.

thanks,

TC

Clearing associated dropdown fields
 

Debra,

Thank you for the tip. Works great. If I wanted to do it via programming,
is it possible?

TC

"Debra Dalgleish" wrote:

To control the entries in column A, without programming, you could type NA
in a cell, and name that cell NAList.
Then, in the first column with data validation, Allow: List, and for the
formula enter:

=IF(B2="",Produce,NAList)

If there's an entry in column B, you will only be able to choose N/A in
column A.

"TC" wrote in message
...
Hello,

I have a spreadsheet with a dropdown list. When a particular item is
selected from the dropdown list, a second field is populated. For
instance,
the dropdown menu is in cell A1, if a selection is made then B2 is
populated.
My issue is the following: If an item is selected from A1, B2 will be
populated, but if the person changes the item in A1, the previous value
remains in B2. Is it possible to "clear the field once A1 has changed
values?
Can I do this w/o VB? Any help would be much appreciated.

thanks,

TC