Results 1 to 9 of 9

Assign values to dropdown menu selections

Threaded View

  1. #1
    Registered User
    Join Date
    08-22-2011
    Location
    St. Paul, MN
    MS-Off Ver
    Excel 2010
    Posts
    13

    Assign values to dropdown menu selections

    Hello,


    I have a dropdown menu in cell A9 with 5 selections in it. I want 4 of the selections to have cells automatically populate when they are selected (I have embedded IF statements into the cells that I want to change). However, I want to have one of the selections in the dropdown menu be an "open" selection, where I can enter in my own values in the same cells that would be populated if one of the other 4 selections were picked.

    Does anybody know how I can tell the IF statement to allow me to input my own data when the "open" selection is chosen, while still re-populating the fields when the other 4 selections are picked?

    Unfortunately, I can't upload an example because there is private information that I can't share. If you want me to clarify anything, please let me know!

    Thanks!
    Last edited by gugg7378; 08-24-2011 at 04:24 PM.

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