VBA Code to Serach & Select Data

[JonRowland]

I currently have a Excel97 file which lists orders recevied. What I want is upon opening the file to run a macro which will search the whole sheet and identify any orders recieved 14 days prior to the today's date & have not been dispatched and copy these onto a new worksheet for review.

It would appear that this should be easy as I have a date in Col D when the order was received and in Col E either N for not dispatched or D is it has, but I can't work it out.

My thoughts were to add a filter put I can't seem to get it to work out today-14.

Anyone help?

Jon

 

[stuartford]

would this do


Tday = Now - 14


Tday
the variable for todays date

and

NOW - 14

should work fine