Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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/ |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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/ |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Date Search | Excel Discussion (Misc queries) | |||
Can't find certain date in search | Excel Worksheet Functions | |||
how to search by date | Excel Discussion (Misc queries) | |||
search for latest date | Excel Worksheet Functions | |||
Search by Date | Excel Programming |