software

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 quot;clear the field once A1 has changed values?
Can I do this w/o VB? Any help would be much appreciated.

thanks,

TC

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=quot;quot;,Produce,NAList)

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

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

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

TC

quot;Debra Dalgleishquot; wrote:

gt; To control the entries in column A, without programming, you could type NA
gt; in a cell, and name that cell NAList.
gt; Then, in the first column with data validation, Allow: List, and for the
gt; formula enter:
gt;
gt; =IF(B2=quot;quot;,Produce,NAList)
gt;
gt; If there's an entry in column B, you will only be able to choose N/A in
gt; column A.
gt;
gt; quot;TCquot; gt; wrote in message
gt; ...
gt; gt; Hello,
gt; gt;
gt; gt; I have a spreadsheet with a dropdown list. When a particular item is
gt; gt; selected from the dropdown list, a second field is populated. For
gt; instance,
gt; gt; the dropdown menu is in cell A1, if a selection is made then B2 is
gt; populated.
gt; gt; My issue is the following: If an item is selected from A1, B2 will be
gt; gt; populated, but if the person changes the item in A1, the previous value
gt; gt; remains in B2. Is it possible to quot;clear the field once A1 has changed
gt; values?
gt; gt; Can I do this w/o VB? Any help would be much appreciated.
gt; gt;
gt; gt; thanks,
gt; gt;
gt; gt; TC
gt;
gt;
gt;