+ Reply to Thread
Results 1 to 4 of 4

Updating cells based on selection from drop down list data validation

  1. #1
    Registered User
    Join Date
    05-24-2013
    Location
    London, ON
    MS-Off Ver
    Excel 2007
    Posts
    43

    Updating cells based on selection from drop down list data validation

    I'm using Excel 2007. I would like to seek some advise on how I may update cells after selecting a status from a drop down list.

    Basically I have created a simplified version of what I intend to have. On the 1st tab “Master”, I will fill up a table with information. I want the information to pre-populate to the remaining tabs depending on the item selected in Column I (Status field). (Column I is a drop down list hidden at the bottom of the spreadsheet). Upon selection of the Status from the drop down list, I would like the cells to display (fetch) the data from the “Master” worksheet.
    Attached Files Attached Files

  2. #2
    Forum Guru Pete_UK's Avatar
    Join Date
    12-31-2011
    Location
    Warrington, England
    MS-Off Ver
    Office 2019 (still learning)
    Posts
    21,256

    Re: Updating cells based on selection from drop down list data validation

    Take a look at this thread from a couple of days ago:

    http://www.excelforum.com/excel-form...xed-value.html

    By having the drop-down on the subsidiary list, you don't need to have separate sheets for each category - it acts like a filter but on a separate sheet from the Master sheet.

    Hope this helps.

    Pete

  3. #3
    Registered User
    Join Date
    05-24-2013
    Location
    London, ON
    MS-Off Ver
    Excel 2007
    Posts
    43

    Re: Updating cells based on selection from drop down list data validation

    Hi Pete
    This would work really well....but the end client wants the tabs. They feel it would be easier for them to understand by seeing the tabs instead of selecting from a drop down.

  4. #4
    Forum Guru Pete_UK's Avatar
    Join Date
    12-31-2011
    Location
    Warrington, England
    MS-Off Ver
    Office 2019 (still learning)
    Posts
    21,256

    Re: Updating cells based on selection from drop down list data validation

    Okay, I'll put something together for you later on, then.

    Pete

+ 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