See attached file.
I’d like to add VBA to automatically filter a table (see attached example).
I want to filter and keep everything in the table where the value in Column D equals Blue, Black, or Red.
I also want the filter to then keep anything in Column B where the value is equal to any text string or is less than or equal to the date in cell K1.
I don't think AutoFilter can do...
AdvancedFilter.
Please Login or Register to view this content.
Please try
Please Login or Register to view this content.
I tested it. Thanks, by the way. It seemed to do fine for Column D, but it didn't do the next filter on Column B
MissedOriginally Posted by scrabtree23
Please Login or Register to view this content.
Last edited by jindon; 01-07-2021 at 10:02 AM. Reason: Fixed the formula to exclude blank.
Please Login or Register to view this content.
Last edited by sintek; 01-07-2021 at 10:49 AM.
Good Luck
I don't presume to know what I am doing, however, just like you, I too started somewhere...
One-day, One-problem at a time!!!
If you feel I have helped, please click on the star to left of post [Add Reputation]
Also....add a comment if you like!!!!
And remember...Mark Thread as Solved.
Excel Forum Rocks!!!
@sintek
Thanks for the CDbl tip
I'm quite a newbie for VBA.
Why do we convert the Date to double?
To prevent m/d/y d/m/y conflict ?
Last edited by Bo_Ry; 01-07-2021 at 11:03 AM.
Dates are stored as numbers...Cdbl() changes to double for filter conversion...
Can make use of Clng() or Cdate() in some cases...
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks