+ Reply to Thread
Results 1 to 4 of 4

Changing the value of a dropdown list automatically

  1. #1
    Registered User
    Join Date
    04-07-2010
    Location
    Yeovil, England
    MS-Off Ver
    Excel 2007
    Posts
    40

    Changing the value of a dropdown list automatically

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

  2. #2
    Forum Expert pike's Avatar
    Join Date
    12-11-2005
    Location
    Alstonville, Australia
    MS-Off Ver
    2016
    Posts
    5,327

    Re: Changing the value of a dropdown list automatically

    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
    If the solution helped please donate to RSPCA

    Site worth visiting: Rabbitohs

  3. #3
    Registered User
    Join Date
    04-07-2010
    Location
    Yeovil, England
    MS-Off Ver
    Excel 2007
    Posts
    40

    Re: Changing the value of a dropdown list automatically

    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

  4. #4
    Forum Expert pike's Avatar
    Join Date
    12-11-2005
    Location
    Alstonville, Australia
    MS-Off Ver
    2016
    Posts
    5,327

    Re: Changing the value of a dropdown list automatically

    what about a macro solution?

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1