+ Reply to Thread
Results 1 to 2 of 2

Macro to filter and delete records from two days to present

  1. 05-01-2018, 04:36 AM #1
    DavidFC
    DavidFC is offline
    Registered User
    Join Date
    04-15-2018
    Location
    Mexicali, Baja California, Mexico
    MS-Off Ver
    2010 & 2016
    Posts
    18

    Question Macro to filter and delete records from two days to present

    Good day everyone
    I have a table that has a column for interaction dates. The raw data is supposed to be pulled up to two days prior to the current date but sometimes records make it through that shouldn't.
    I need a macro that would filter records from today and yesterday and then delete these records.
    The columns in the table will be fixed but there will be a different number of records each time this macro is run.
    If someone could please help me out that would be very helpful.
    Thank you all very much.
    Reply With QuoteRegister To Reply
  2. 05-01-2018, 04:40 AM #2
    alansidman
    alansidman is offline
    Forum Moderator alansidman's Avatar
    Join Date
    02-02-2010
    Location
    Steamboat Springs, CO
    MS-Off Ver
    MS Office 365 insider Version 2505 Win 11
    Posts
    24,755

    Re: Macro to filter and delete records from two days to present

    Attach a sample workbook. Make sure there is just enough data to demonstrate your need. Include a BEFORE sheet and an AFTER sheet in the workbook if needed to show the process you're trying to complete or automate. Make sure your desired results are shown, mock them up manually if necessary.

    Remember to desensitize the data.

    Click on GO ADVANCED and then scroll down to Manage Attachments to open the upload window.
    Alan עַם יִשְׂרָאֵל חַי


    Change an Ugly Report with Power Query
    Database Normalization
    Complete Guide to Power Query
    Man's Mind Stretched to New Dimensions Never Returns to Its Original Form
    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. Macro acts funny when more than 30 records are present
    By JPWRana in forum Excel Programming / VBA / Macros
    Replies: 18
    Last Post: 05-01-2017, 12:23 PM
  2. Filter only records containing 'x', copy, paste in new sheet, and then delete. Please help
    By jamieswift1977 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 07-12-2013, 05:27 AM
  3. Filter records, paste into a different sheet, delete rows from original sheet.
    By gloworm1973 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 03-28-2009, 05:24 AM
  4. Efficient way to filter and delete junk records
    By akabraha in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 09-06-2007, 01:08 PM
  5. Need a macro to select and delete records.
    By jeryst in forum Excel General
    Replies: 1
    Last Post: 01-11-2007, 04:25 PM
  6. how to filter data and delete double records
    By **dan** in forum Excel General
    Replies: 2
    Last Post: 10-17-2006, 06:07 AM
  7. [SOLVED] Macro to filter and display only top 5 records on last sheet
    By sunilkeswani@gmail.com in forum Excel General
    Replies: 1
    Last Post: 11-08-2005, 10:20 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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1