filtering data based on a formula

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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