Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
filtering data based on a formula
I am trying to setup a macro to print out a list of Loaned equipment that is
due to be returned as of the current date (cell containing value of "=today()" is the key). Key to this is filtering the data by referenceing the cell that contains the current date. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
filtering data based on a formula
I'd just record the macro, manually selecting any old date from the drop
down. Then edit the macro, changing the line that reads something like Selection.AutoFilter Field:=7, Criteria1:="06/13/06" , changing the criteria to something like format(date(),"m/d/yy") "Al Z" wrote: I am trying to setup a macro to print out a list of Loaned equipment that is due to be returned as of the current date (cell containing value of "=today()" is the key). Key to this is filtering the data by referenceing the cell that contains the current date. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Macro question | Excel Worksheet Functions | |||
Pull data from another sheet based on certain criteria | Excel Discussion (Misc queries) | |||
formula to count based on data in two different cells/columns | Excel Discussion (Misc queries) | |||
Sort pages? | Excel Discussion (Misc queries) | |||
Importing Data Into Formula Based Cells | Excel Worksheet Functions |