+ Reply to Thread
Results 1 to 4 of 4

Data Validation Lists - Creating lists based on data from another list

  1. #1
    Registered User
    Join Date
    12-18-2008
    Location
    Sydney, Australia
    Posts
    94

    Data Validation Lists - Creating lists based on data from another list

    Hi there,

    Im trying to make reporting processes easier by being able to select operational centres within a business unit. I need to be able to set up both as data validation lists (drop down lists) but need for the data to change based on selection from the first data validation list.

    For example, when you select BIF as the business unit, i only want a list of operational centres under them to be in the data validation list. When you select PAE as the business unit, i only want there operational centres displayed.

    I have tried a few ways to do this - but am totally lost.

    I have attached a sample spreadsheet detailing what i mean.

    Any help that can be provided will be greatly appreciated.
    Attached Files Attached Files
    Last edited by fmluder93; 09-02-2010 at 03:03 AM.

  2. #2
    Valued Forum Contributor
    Join Date
    05-19-2010
    Location
    Ontario, Canada
    MS-Off Ver
    Excel 2010
    Posts
    391

    Re: Data Validation Lists - Creating lists based on data from another list

    will somthing like this work for you --- I made a change to your file --- name range and used indirect
    Attached Files Attached Files

  3. #3
    Registered User
    Join Date
    12-18-2008
    Location
    Sydney, Australia
    Posts
    94

    Re: Data Validation Lists - Creating lists based on data from another list

    This is PERFECT !!! and exactly what i needed. Thank you very very much

  4. #4
    Valued Forum Contributor
    Join Date
    05-19-2010
    Location
    Ontario, Canada
    MS-Off Ver
    Excel 2010
    Posts
    391

    Re: Data Validation Lists - Creating lists based on data from another list

    your very welcome

+ 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