JonRowland
Active Member
- Joined
- May 9, 2003
- Messages
- 416
- Office Version
- 365
- Platform
- Windows
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
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