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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Pivot table macro filter data between yesterday and today (date+time) 0
Macro filter based on date criteria 4
Creating an update query that uses multiple parameters 2
Filtering with SUMIFS 1
FILTER FORMULA 1
Filter Data based on cell value 3
Sumproduct formula 3
formula error 1

Back
Top