Results 1 to 6 of 6

Help: Advance Filter

Threaded View

  1. #1
    Forum Contributor
    Join Date
    05-09-2010
    Location
    Malaysia
    MS-Off Ver
    Excel 2010
    Posts
    212

    Help: Advance Filter

    I want to make the file more automatic and user friendly. All the data set as table and it will auto run if there is any additional information.
    Refer to sheet [Search], maximum 5 criteria is allowed to search the data.
    Problem is all database will be shown if row 6 is not in use and left it blank. How to tell program blank mean not in use?

    Please refer to file attached.
    Attached Files Attached Files

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] Cant filter 2 columns even with advance filter
    By pingpong1 in forum Excel General
    Replies: 19
    Last Post: 07-03-2015, 04:40 PM
  2. Advance Filter - vba
    By geliedee in forum Excel General
    Replies: 21
    Last Post: 02-20-2015, 05:06 AM
  3. [SOLVED] Advance Filter help
    By buwa84 in forum Excel General
    Replies: 5
    Last Post: 07-16-2013, 04:46 PM
  4. Advance Filter
    By betmck in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 12-18-2007, 02:48 PM
  5. Advance filter
    By Obi-Wan Kenobi in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 03-21-2006, 11:53 AM
  6. Advance filter search does not filter an exact match
    By cfiiland in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 06-10-2005, 08:05 AM
  7. advance filter
    By DANmcc in forum Excel General
    Replies: 2
    Last Post: 04-20-2005, 06:06 PM

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