+ Reply to Thread
Results 1 to 6 of 6

Delete rows when criteria met in date and time

  1. 04-19-2015, 02:33 PM #1
    MicroTees is offline
    Forum Contributor
    Join Date
    06-10-2014
    Location
    CANADA
    MS-Off Ver
    2016
    Posts
    118

    Delete rows when criteria met in date and time

    Dear experts

    I have set of data which contains date and time i need vba code to delete row where those conditions met

    i want select first 1st march in C:C column and then time between 12:00 am to 8:30 am in B:B column ,if wherever criteria met in two column delete those rows


    find the attachment
    regards
    john
    Attached Files Attached Files
    Reply With QuoteRegister To Reply
  2. 04-19-2015, 03:30 PM #2
    ARowbot is offline
    Valued Forum Contributor
    Join Date
    11-12-2014
    Location
    Nottingham
    MS-Off Ver
    2013
    Posts
    383

    Re: Delete rows when criteria met in date and time

    Code updated

    Please Login or Register  to view this content.
    Last edited by ARowbot; 04-19-2015 at 03:37 PM. Reason: Mistake in code
    Reply With QuoteRegister To Reply
  3. 04-19-2015, 07:31 PM #3
    mike7952 is offline
    Forum Expert mike7952's Avatar
    Join Date
    12-17-2011
    Location
    Florida
    MS-Off Ver
    Excel 2007, Excel 2016
    Posts
    3,551

    Re: Delete rows when criteria met in date and time

    try this

    Please Login or Register  to view this content.
    Thanks,
    Mike

    If you are satisfied with the solution(s) provided, please mark your thread as Solved.
    Select Thread Tools-> Mark thread as Solved.
    Reply With QuoteRegister To Reply
  4. 04-20-2015, 02:16 PM #4
    MicroTees is offline
    Forum Contributor
    Join Date
    06-10-2014
    Location
    CANADA
    MS-Off Ver
    2016
    Posts
    118

    Re: Delete rows when criteria met in date and time

    Thanks alot sir it works perfectly I just have small obligation on code instead of deleting can i cut data and move to next sheet?
    Reply With QuoteRegister To Reply
  5. 04-20-2015, 03:57 PM #5
    ARowbot is offline
    Valued Forum Contributor
    Join Date
    11-12-2014
    Location
    Nottingham
    MS-Off Ver
    2013
    Posts
    383

    Re: Delete rows when criteria met in date and time 

    Please Login or Register  to view this content.
    Reply With QuoteRegister To Reply
  6. 04-21-2015, 12:47 PM #6
    MicroTees is offline
    Forum Contributor
    Join Date
    06-10-2014
    Location
    CANADA
    MS-Off Ver
    2016
    Posts
    118

    Re: Delete rows when criteria met in date and time

    Dear sir It not working for me its not moving criteria met data to new sheet....?
    One more last steps need to be add along with previous 2 steps In the s:s column if criteria B or D met that rows also should move to newsheet and delete in rawdatasheet?
    sorry sir i reallly burden to you please help on this Find the attachment
    Attached Files Attached Files
    Last edited by MicroTees; 04-21-2015 at 12:52 PM. Reason: attachment
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. in a table with date and time, how to automatically delete first rows when time passed?
    By netanel99 in forum Excel Programming / VBA / Macros
    Replies: 8
    Last Post: 06-20-2014, 02:40 AM
  2. Macro to delete certain rows if DATE criteria is met
    By lukasz_rz in forum Excel Programming / VBA / Macros
    Replies: 13
    Last Post: 02-28-2014, 11:30 AM
  3. Macro to delete certain rows if DATE criteria is met
    By lukasz_rz in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 02-26-2014, 01:16 PM
  4. Delete Rows Based on Time criteria
    By Roelandu in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 09-26-2012, 08:07 AM
  5. find date&time then delete rows after that.
    By dineshkumar_kd in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 02-10-2012, 02:39 AM

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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1