+ Reply to Thread
Results 1 to 2 of 2

How do I create Filtered Pick Lists?

  1. #1
    Registered User
    Join Date
    07-23-2009
    Location
    Ottawa, Canada
    MS-Off Ver
    Excel 2007
    Posts
    1

    How do I create Filtered Pick Lists?

    i have a sheet with 4 columns, and hundreds of rows of data.

    for ex: Country, division, team, Employee_Name

    On another sheet i need to create pick lists from that data. (i have no problem with that). What i need is to figure out how do i filter those list.

    for example, on another sheet where i enter my data i need to enter the info that i already taltked about (i use pick list to speed it up and to avoid fat fingering my data) if i pick USA, as the country, the pick list in the division colomn on the other sheet will only show me divisions that are in the US. and so on...

    How do i do that?

    Thanks

  2. #2
    Forum Expert sweep's Avatar
    Join Date
    04-03-2007
    Location
    Great Sankey, Warrington, UK
    MS-Off Ver
    2003 / 2007 / 2010 / 2016 / 365
    Posts
    3,445

    Re: How do I create Filtered Pick Lists?

    Hi,

    Try taking a look here

    http://www.contextures.com/xlDataVal13.html
    Rule 1: Never merge cells
    Rule 2: See rule 1

    "Tomorrow I'm going to be famous. All I need is a tennis racket and a hat".

+ 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