+ Reply to Thread
Results 1 to 3 of 3

Advanced Filter is working manually but not automatically

  1. #1
    Valued Forum Contributor rwgrietveld's Avatar
    Join Date
    09-02-2008
    Location
    Netherlands
    MS-Off Ver
    XL 2007 / XL 2010
    Posts
    1,671

    Advanced Filter is working manually but not automatically

    I have made a small routine that updates an adv. Filter automatically, but is doesn't provide me the right outcome (seems it does nothing)

    I also recorded my actions and also here an empty outcome.

    The attachement will explain ...
    Attached Files Attached Files
    Last edited by rwgrietveld; 01-28-2010 at 08:54 AM.
    Looking for great solutions but hate waiting?
    Seach this Forum through Google

    www.Google.com
    (e.g. +multiple +IF site:excelforum.com/excel-general/ )

    www.Google.com
    (e.g. +fill +combobox site:excelforum.com/excel-programming/ )

    Ave,
    Ricardo

  2. #2
    Forum Guru romperstomper's Avatar
    Join Date
    11-04-2008
    Location
    A1
    MS-Off Ver
    Most
    Posts
    12,302

    Re: Advanced Filter is working manually but not automatically

    If you change your criteria to use the DATE function, it should work. See attached.
    Attached Files Attached Files
    Remember what the dormouse said
    Feed your head

  3. #3
    Valued Forum Contributor rwgrietveld's Avatar
    Join Date
    09-02-2008
    Location
    Netherlands
    MS-Off Ver
    XL 2007 / XL 2010
    Posts
    1,671

    Re: Advanced Filter is working manually but not automatically

    Hmm,

    That simple ! Thanks once again RomperStomper.

+ 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