Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Filter by a Date that link to a cell
Hi!
I am wondering if it's possible to use filter to select data with dates that are after a certain date I enter in a cell. Thank you very much! Ken |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Filter by a Date that link to a cell
You can use Data Filter Advanced Filter feature. In two consecutive rows
that do not risk to disappear when you apply a filter (it simply makes your life easier when a filter is already applied and you want to change the date), put in the top cell the column name of your dates and below the date value with a comparison operator like , < or =. Something like B1 and B2: Date Of Shipment =13-Aug-2007 Then select the range to filter (example A4:X456), and click on Data Filter Advanced Filter, and put in the criteria the range of the two cells above (B1:B2). To speed up the process, you can add to one toolbar the command Data Filter Advanced Filter, so in two click (one on the button, then one on OK in the new window) you will have a semi-automated system. Stephane Quenson. -- Message posted via OfficeKB.com http://www.officekb.com/Uwe/Forums.a...excel/200708/1 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Filter by a Date that link to a cell | Excel Discussion (Misc queries) | |||
How to link a cell in date format without displaying it as 0-Jan? | Excel Worksheet Functions | |||
link cell in excel to current date | Excel Discussion (Misc queries) | |||
Is there a way to link Auto Filter values to a Cell | Excel Worksheet Functions | |||
Using date, link to a cell | Excel Discussion (Misc queries) |