+ Reply to Thread
Results 1 to 7 of 7

Date autofilter problem - Excel 2013 version

  1. #1
    Forum Contributor HerryMarkowitz's Avatar
    Join Date
    09-10-2012
    Location
    Istanbul / Turkey
    MS-Off Ver
    2013 - Win10 - 64bit
    Posts
    1,007

    Date autofilter problem - Excel 2013 version

    Greetings,
    I want to filter dates which are before 28.01.2014.
    Open enclosed file and run following macro.
    Please Login or Register  to view this content.
    Why autofilter does not work properly ?
    Interesting issue:
    After running above macro go inside of autofilter and see that everything is okey !

    Note: If you can get yellow coloured cell after running above macro, that means this code works properly for you.
    Attached Files Attached Files
    Last edited by HerryMarkowitz; 01-20-2014 at 10:51 PM.
    Sub DontForgetThese()
         If Your thread includes any code Then Please use code tags...
         If Your thread has been solved Then Please mark as solved...
         If Anybody has helped to you Then Please add reputation...
    End Sub

  2. #2
    Forum Moderator alansidman's Avatar
    Join Date
    02-02-2010
    Location
    Steamboat Springs
    MS-Off Ver
    MS Office 365 Win 11 Home 64 Bit
    Posts
    21,489

    Re: Date autofilter problem - Excel 2013 version

    I opened your file and ran the macro. It returns one date which is less than a week from today, which is what your criteria calls for. All other dates are further into the future. I don't understand what your issue is. The date returned was Jan 23, 2014. If this is not what you want, then please explain further.
    Alan


    Have you debugged your code?
    Database Normalization
    Complete Guide to Power Query
    Man's Mind Stretched to New Dimensions Never Returns to Its Original Form

  3. #3
    Forum Contributor HerryMarkowitz's Avatar
    Join Date
    09-10-2012
    Location
    Istanbul / Turkey
    MS-Off Ver
    2013 - Win10 - 64bit
    Posts
    1,007

    Re: Date autofilter problem - Excel 2013 version

    That means that code works for your computer and for your excel...
    We need to check that code in excel 2013 ?

  4. #4
    Forum Expert nilem's Avatar
    Join Date
    10-22-2011
    Location
    Ufa, Russia
    MS-Off Ver
    2013
    Posts
    3,376

    Re: Date autofilter problem - Excel 2013 version

    Hi HerryMarkowitz,
    try
    Please Login or Register  to view this content.

  5. #5
    Forum Contributor HerryMarkowitz's Avatar
    Join Date
    09-10-2012
    Location
    Istanbul / Turkey
    MS-Off Ver
    2013 - Win10 - 64bit
    Posts
    1,007

    Re: Date autofilter problem - Excel 2013 version

    Hi nilem, solved. Thank you.
    I need further one.
    Following code supposed to filter dates before today + 7.
    But this code also need a repairment !
    Please Login or Register  to view this content.

  6. #6
    Forum Expert nilem's Avatar
    Join Date
    10-22-2011
    Location
    Ufa, Russia
    MS-Off Ver
    2013
    Posts
    3,376

    Re: Date autofilter problem - Excel 2013 version

    Please Login or Register  to view this content.

  7. #7
    Forum Contributor HerryMarkowitz's Avatar
    Join Date
    09-10-2012
    Location
    Istanbul / Turkey
    MS-Off Ver
    2013 - Win10 - 64bit
    Posts
    1,007

    Re: Date autofilter problem - Excel 2013 version

    Perfect. Solved.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Replies: 3
    Last Post: 11-22-2013, 11:55 AM
  2. Simple formula to display a date (10/19/2013) as text (October 2013)
    By benyben123 in forum Excel Formulas & Functions
    Replies: 7
    Last Post: 10-20-2013, 03:47 AM
  3. Excel 2013 date updating problem
    By samson jerry in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 08-08-2013, 02:30 PM
  4. problem in exporting as pdf in excel 2013
    By contact_ankit86 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 06-20-2013, 01:21 AM
  5. [SOLVED] Excel Autofilter options (version)?
    By HotRod in forum Excel Programming / VBA / Macros
    Replies: 9
    Last Post: 04-28-2005, 09: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