+ Reply to Thread
Results 1 to 5 of 5

Delete all rows with a date greater than ...

  1. #1
    Registered User
    Join Date
    11-08-2014
    Location
    Malaysia
    MS-Off Ver
    2010
    Posts
    84

    Question Delete all rows with a date greater than ...

    Hello members,
    Could you please help me to "delete all rows with a date greater than" (e.g. 31/12/2010).
    Data are in 3 columns and dates are in Col A.

    date greater.png
    Thank you
    Last edited by Moriexcel; 12-14-2014 at 10:07 AM.

  2. #2
    Forum Moderator davesexcel's Avatar
    Join Date
    02-19-2006
    Location
    Regina
    MS-Off Ver
    MS 365
    Posts
    13,481

    Re: Delete all rows with a date greater than ...

    It's hard to work with a picture, why not supply a sample workbooK

  3. #3
    Forum Moderator davesexcel's Avatar
    Join Date
    02-19-2006
    Location
    Regina
    MS-Off Ver
    MS 365
    Posts
    13,481

    Re: Delete all rows with a date greater than ...

    Try this.
    Please Login or Register  to view this content.
    Last edited by davesexcel; 12-14-2014 at 08:26 AM.

  4. #4
    Registered User
    Join Date
    11-08-2014
    Location
    Malaysia
    MS-Off Ver
    2010
    Posts
    84

    Re: Delete all rows with a date greater than ...

    Many thanks. It works well. I already clicked on * .
    Just to learn, May I ask, what's the meaning of
    Please Login or Register  to view this content.
    ?

  5. #5
    Forum Moderator davesexcel's Avatar
    Join Date
    02-19-2006
    Location
    Regina
    MS-Off Ver
    MS 365
    Posts
    13,481

    Re: Delete all rows with a date greater than ...

    It's supposed to ensure that numbers get deleted not text, so a header won't get deleted.

+ 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. Delete a Row If A Column Contains a Date Greater than 1/0/00
    By hbs929 in forum Excel Programming / VBA / Macros
    Replies: 14
    Last Post: 08-28-2014, 09:55 AM
  2. [SOLVED] Delete Rows greater than current date
    By kesavanprabhu in forum Excel Programming / VBA / Macros
    Replies: 9
    Last Post: 06-13-2013, 10:57 AM
  3. [SOLVED] Delete rows with Start date greater than 30 days
    By kbaruin in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 09-27-2012, 04:56 AM
  4. Delete Rows Column F if greater than or equal to zero.
    By EJensen in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 05-14-2009, 10:06 PM
  5. Delete Rows with Value greater than X
    By STEVEB in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 07-26-2005, 04:08 PM

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