filtering data based on a formula

A

Al Z

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.
 
B

bpeltzer

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")
 
Top