+ Reply to Thread
Results 1 to 2 of 2

How to Filter a Table Using 2 Criteria (Show Cells with Today's Date & Blanks)

  1. #1
    Registered User
    Join Date
    02-07-2023
    Location
    Wisconsin, USA
    MS-Off Ver
    Microsoft Office 2016
    Posts
    6

    How to Filter a Table Using 2 Criteria (Show Cells with Today's Date & Blanks)

    I'm trying to create a macro to filter a table so it only shows rows that have today's date as well as the blank rows.
    I can easily get it to filter one or the other, but when I try to get it to show both, it just shows the blanks right now.

    I have a sheet called "Daily Goal and Sale Tracker"
    Within that sheet is a table called "Customer_Tally_Table"
    Within that table is a column for "Date", which is column 1

    Here is what I tried:

    Please Login or Register  to view this content.
    The above code did not work, but I figured maybe it was because the cells that have the date are also time-stamped, in the following format: 3/14/12 1:30PM
    So, I tried to change it so it would only look at the date, and not get "Confused " by the time, and this is the code I tried:

    Please Login or Register  to view this content.
    Both of these codes only showed me the blank rows, but I desperately need it to show both.
    Any suggestions?

    Thanks!

  2. #2
    Forum Guru
    Join Date
    03-02-2006
    Location
    Los Angeles, Ca
    MS-Off Ver
    WinXP/MSO2007;Win10/MSO2016
    Posts
    12,620

    Re: How to Filter a Table Using 2 Criteria (Show Cells with Today's Date & Blanks)

    Please Login or Register  to view this content.
    no file to test with...
    Ben Van Johnson

+ 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. [SOLVED] How can I use FILTER to show results where any column contains today's date?
    By jmdenson in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 10-28-2021, 07:31 PM
  2. Filter data and show in different table based on multiple criteria
    By Zaid in forum Excel Formulas & Functions
    Replies: 7
    Last Post: 04-08-2020, 05:18 PM
  3. vba to filter table by today's date up to 10 days. and save as new version
    By The Fly in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 08-01-2014, 02:15 PM
  4. How to show blanks cells in this excel macro filter ?any idea?
    By meonly123 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 07-16-2014, 02:14 AM
  5. Replies: 4
    Last Post: 05-08-2014, 10:13 AM
  6. Replies: 1
    Last Post: 09-30-2012, 03:01 PM
  7. Replies: 6
    Last Post: 03-04-2010, 03:04 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