+ Reply to Thread
Results 1 to 3 of 3

Excel 2007 : Populating multiple cells based on single cell input

  1. #1
    Registered User
    Join Date
    09-23-2010
    Location
    North Carolina, USA
    MS-Off Ver
    Excel 2007
    Posts
    2

    Populating multiple cells based on single cell input

    I work for a company with retail stores grouped into regions and smaller districts.

    Let's say region number 1 consists of 3 districts - # 123, #234, #345

    Each of those districts contains multiple stores
    #123 - stores x, y, z
    #234 - stores a,b,c
    #345 - stores d,e,f

    I want to be able to create a list of districts/stores based on a user inputs. I already have data validation lists set up so that a user can select a particular region and further select a particular district that belongs to that region, and further select stores that belong to that district.

    If user selects Region 1 in the first data validation I need a separate list to populate as below as:
    # 123
    # 234
    # 345

    If a user then selects district # 123 from the second data validation I need a list of stores belonging to that district to populate as:
    x
    y
    z

    Is this possible?

    Here's how the final spreadsheet looks with the 3 data validation drop downs:

    \1

  2. #2
    Forum Moderator zbor's Avatar
    Join Date
    02-10-2009
    Location
    Croatia
    MS-Off Ver
    365 ProPlus
    Posts
    16,054

    Re: Populating multiple cells based on single cell input

    Look here..
    Is this what you looking for?

    http://www.contextures.com/xldataval02.html
    Never use Merged Cells in Excel

  3. #3
    Registered User
    Join Date
    09-23-2010
    Location
    North Carolina, USA
    MS-Off Ver
    Excel 2007
    Posts
    2

    Re: Populating multiple cells based on single cell input

    Close - I already have my dependant data validation lists created and working as needed.

    All I want to have happen is the list of districts or stores populate into the cells below, as pointed out in the jph attached to my original post.

    Thanks!

+ 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