+ Reply to Thread
Results 1 to 2 of 2

searching list using certain criteria from boxes

  1. #1
    Registered User
    Join Date
    05-01-2006
    Posts
    16

    searching list using certain criteria from boxes

    I have a list of entries which i have some search criteria in boxes that the user can select from. Depending on how many of the criteria is selected I want to pull off every entry in the list that matches these criteria.

    I have managed to get this working for all criteria selected, but if the user only choose 2 or 3 out of the 7 search criteria then I am struggling to think of how to do this other than do about 1000 if statements for every combination.

    Please help?

    Thanks

    Andy

  2. #2
    Forum Contributor
    Join Date
    09-04-2006
    Location
    Yorkshire, England
    Posts
    267

    Doran eats to many biscuits

    Andria

    could you use an IF formula in vba to show if cell is blank move on to the next one and so on?

    shout if u need any help
    JR
    Versions
    Mac OS X 'Leopard'
    Mac MS Office Excel 2004
    Windows XP
    MS Excel 2002
    MS Excel 2003

+ 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