filtering data based on a formula

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

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

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