Changing the value of a dropdown list automatically

**Richmate** · 06-04-2010, 07:13 AM

Hi All

All cells from A6:G12 on the attached spreadsheet contains a drop down list.

What I would like to happen is that when I choose Deleted in Column A It will change all other columns in that row to N/A automatically. Any other value from the list in column A will be variable so will have to be inputed manually.

Is there a way of doing this. Im hoping for a formula solution rather than a macro if possible.

Hope that makes sense

Thanks in advance

Rich

**pike** · 06-04-2010, 10:15 PM

Hi Richmate
Not quite what you need but try
in B8 Validation formula=IF(A8="Deleted",L6,$K$6:$K$7)
where L6 = N/A

**Richmate** · 06-09-2010, 09:51 AM

Hi Thanks for the reply

Sorry I havent replied earlier but Ive been out of office for a while.

I tried this but, like you said it not quite what I need.

Thanks Anyway

Rich