+ Reply to Thread
Results 1 to 1 of 1

Using Mutiple inputs from data validation lists to search sheet and return multiple record

  1. #1
    Registered User
    Join Date
    06-13-2013
    Location
    Melbourne, Australia
    MS-Off Ver
    Excel 2010
    Posts
    2

    Post Using Mutiple inputs from data validation lists to search sheet and return multiple record

    Hi There,

    First time posting so I hope its not a silly question! After spending a bit of time looking for some solutions for this i've come up stuck. Basically I want to manipulate the filter options on one sheets using data validation lists on another (which are generated on startup using VBA to search each column and return unique results) and then return all the results into a seperate page.

    I have tried to use the following code located in a seperate module but it returns an error: "The extract range has a missing or illegal field name"

    Please Login or Register  to view this content.
    I get the impression this is because of how my criteria range is setup. Its layed out as below:

    Consultant | *Consultant Name Here*
    Agent Number | *Agent Number Here*
    Etc..

    Say it has the criteria in A1 and the input in B1.

    In some tutorials I have seen the criteria with the heading and the top and the input directly under it (So criteria in A1 and input in A2)

    Or does this method not a allow for partial inputs, for instance if I only wanted to filter by consultant and not by agent as well, would this error?

    Any ideas?
    Last edited by jeffreybrown; 06-16-2013 at 10:48 AM. Reason: As per Forum Rule #3, please use code tags…Thanks.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Tags for this Thread

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