+ Reply to Thread
Results 1 to 9 of 9

filtered data validation

  1. #1
    Registered User
    Join Date
    10-05-2012
    Location
    Italy
    MS-Off Ver
    Excel 2010
    Posts
    7

    filtered data validation

    Hi everybody, i will describe my problem:
    I have a list of streets on one column (different sheet) and i'd love to give my users the possibility to choose a street based on whatever they write in a cell. a kind of dynamic data validation...
    I will try to explain myself better with an example:


    i have this list of streets:
    streets
    high street
    republic street
    bond road
    fullend street
    nice street
    endington street
    all high street

    a user would write "high" in a cell and press the data validation arrow, at that point only
    high street
    all high street
    would be displayed.


    is it possible? i was thinking about a range filtered right before the click on the arrow or something like that

    i appreciate your help. thanks in advance
    Attached Files Attached Files
    Last edited by Gotrekk; 10-05-2012 at 06:21 AM. Reason: attachment

  2. #2
    Forum Contributor
    Join Date
    09-05-2012
    Location
    It's more fun in the Philippines :D
    MS-Off Ver
    Excel 2007
    Posts
    209

    Re: VBA/MACRO: Let the user pick a value from another filtered column

    Hi Gotrekk,

    I suggest you attach your workbook so we can help you with that one.

    Regards,
    thisisgerald
    Don't forget to mark your thread as [SOLVED].

  3. #3
    Registered User
    Join Date
    10-05-2012
    Location
    Italy
    MS-Off Ver
    Excel 2010
    Posts
    7

    Re: VBA/MACRO: Let the user pick a value from another filtered column

    here we go, you can find the file attached
    Attached Files Attached Files

  4. #4
    Forum Moderator Fotis1991's Avatar
    Join Date
    10-11-2011
    Location
    Athens(The homeland of the Democracy!). Greece
    MS-Off Ver
    Excel 1997!&2003 & 2007&2010
    Posts
    13,744

    Re: filtered data validation

    Hi

    See if my example, helps you.
    Attached Files Attached Files
    Regards

    Fotis.

    -This is my Greek whisper to Europe.

    --Remember, saying thanks only takes a second or two. Click the little star * below, to give some Rep if you think an answer deserves it.

    Advanced Excel Techniques: http://excelxor.com/

    --KISS(Keep it simple Stupid)

    --Bring them back.

    ---See about Acropolis of Athens.

    --Visit Greece.

  5. #5
    Registered User
    Join Date
    10-05-2012
    Location
    Italy
    MS-Off Ver
    Excel 2010
    Posts
    7

    Re: filtered data validation

    Quote Originally Posted by Fotis1991 View Post
    Hi

    See if my example, helps you.
    Thanks for the interest but that's not what i'm after... i need to write the partial name in C2 and get those results in the dropdown of C2.

  6. #6
    Forum Contributor
    Join Date
    09-05-2012
    Location
    It's more fun in the Philippines :D
    MS-Off Ver
    Excel 2007
    Posts
    209

    Re: filtered data validation

    @Gotrekk,

    I'm currently working with this and it's giving me a challenge.
    I'm only having problem because I can use the autocomplete on the streets sheet and not on the main sheet.

    Regards,
    thisisgerald

  7. #7
    Registered User
    Join Date
    10-05-2012
    Location
    Italy
    MS-Off Ver
    Excel 2010
    Posts
    7

    Re: filtered data validation

    could you show me where are you at? i may try to help! ehehe

    regards!

    Quote Originally Posted by thisisgerald View Post
    @Gotrekk,

    I'm currently working with this and it's giving me a challenge.
    I'm only having problem because I can use the autocomplete on the streets sheet and not on the main sheet.

    Regards,
    thisisgerald

  8. #8
    Registered User
    Join Date
    10-05-2012
    Location
    Italy
    MS-Off Ver
    Excel 2010
    Posts
    7

    Re: filtered data validation

    Is there an event when u push the dropdown arrow?

  9. #9
    Registered User
    Join Date
    10-05-2012
    Location
    Italy
    MS-Off Ver
    Excel 2010
    Posts
    7

    Re: filtered data validation

    getting closer and closer by myself... one of the last things i need is to run a script right before i click the dropdown arrow.... is there any way to do it?
    Private Sub Worksheet_Change runs after the arrow click

+ 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