Excel VBA Filtering on Time
When filtering data the website has focused acutely on filtering information which meets a certain criteria or between two criteria. The site has dealt with filtering on multiple criteria and filtering between dates. Some of these concepts are quite difficult as repeating Excel's tick by filter is not always easy to replicate in VBA. I came across an interesting problem while working for a client. The range of cells had the date and time in the cell, the idea was to get quantity data from a dataset if it was past a certain time.
Read MoreFeatured Posts
Recent Posts
Split File into Parts and Save to Directory April 20, 2024
Most Popular Author December 14, 2023
Creating an Excel Dashboard - A Guide with Templates December 8, 2023
Real Estate Excel Dashboard October 11, 2023
Updating Excel Dashboards September 29, 2023
TheSmallman in Another Top Blog Rank April 24, 2023
Project Tracking Dashboard March 25, 2023
Excel Unique Formula September 17, 2022
Horizontal Range to Vertical Range in Excel June 15, 2022
Hiding Rows Quickly with VBA May 20, 2022