Help with date search
I'm looking to create a search function for an Excel workbook that will
find all dates prior to the date entered. As far as I can tell, Excel can only find ones that match. I don't know VB, so could use help. Thanks --- Message posted from http://www.ExcelForum.com/ |
Help with date search
Why not use one of the filter functions. (Data=Filter=Autofilter, select
custom in the dropdown for that column and then use before and enter your date. you can turn on the macro recorder if you need code to perform the same way. -- Regards, Tom Ogilvy "Gorillaman13 " wrote in message ... I'm looking to create a search function for an Excel workbook that will find all dates prior to the date entered. As far as I can tell, Excel can only find ones that match. I don't know VB, so could use help. Thanks --- Message posted from http://www.ExcelForum.com/ |
All times are GMT +1. The time now is 05:26 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com