+ Reply to Thread
Results 1 to 4 of 4

drop down lists / data validation

  1. #1
    Registered User
    Join Date
    10-10-2012
    Location
    Edmonton, AB
    MS-Off Ver
    Excel 2010
    Posts
    3

    drop down lists / data validation

    Hello,
    First, let me apologize if this has been covered somewhere. I did do a search, but couldn't see quite what I was looking for. This might be because I'm a relatively new / basic excel user..

    I have a spreadsheet with a list of items on sheet one, and sheet 2 uses this list in drop downs.
    Now, some time after the list was created, a decision has been made to change the terminology used. My question is: I am able to change the item in the list (say from cookie to chocolate cookie), and the new term now appears in the drop down. What I am trying to do, is have all cells where it says cookie, to update to the new term of chocolate cookie. Or - do I need to manually find each instance and re-select from the drop down?

    Appreciate the help! :-)

  2. #2
    Forum Expert tigeravatar's Avatar
    Join Date
    03-25-2011
    Location
    Colorado, USA
    MS-Off Ver
    Excel 2003 - 2013
    Posts
    5,361

    Re: drop down lists / data validation

    CashmereCat,

    Welcome to the forum!
    Use the Find and Replace dialog (ctrl+h) and Replace All
    Hope that helps,
    ~tigeravatar

    Forum Rules: How to use code tags, mark a thread solved, and keep yourself out of trouble

  3. #3
    Registered User
    Join Date
    10-10-2012
    Location
    Edmonton, AB
    MS-Off Ver
    Excel 2010
    Posts
    3

    Re: drop down lists / data validation

    Yikes, that was painfully too easy! Here I was trying to find a function or formula that would do it, since there are many that need to be updated. But that works too!
    Thanks so much for taking the time to answer such a silly question
    And thanks for the welcome.
    I imagine I will be prowling around through the threads a good deal, trying to get my excel skills up.
    CC

  4. #4
    Administrator FDibbins's Avatar
    Join Date
    12-29-2011
    Location
    Duncansville, PA USA
    MS-Off Ver
    Excel 7/10/13/16/365 (PC ver 2310)
    Posts
    52,917

    Re: drop down lists / data validation

    cashmerecat there are no silly questions, just silly answers (i think some1 once said that lol) and feel free to ask whatever forum-related questions you want (silly or not), some1 here will always try to help

    If this answered your question, please take a moment to mark the thread as "solved" - it helps keep things neat and tidy lol, and consider adding the reputation to those that helped (see points 2 & 3 below)
    1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
    2. If your question is resolved, mark it SOLVED using the thread tools
    3. Click on the star if you think someone helped you

    Regards
    Ford

+ 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