VBA Code to Serach & Select Data

JonRowland

Active Member
Joined
May 9, 2003
Messages
376
Office Version
  1. 365
Platform
  1. 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
 

Some videos you may like

Excel Facts

Fastest way to copy a worksheet?
Hold down the Ctrl key while dragging tab for Sheet1 to the right. Excel will make a copy of the worksheet.

stuartford

Active Member
Joined
Nov 28, 2002
Messages
419
would this do


Tday = Now - 14


Tday
the variable for todays date

and

NOW - 14

should work fine
 

Watch MrExcel Video

Forum statistics

Threads
1,122,694
Messages
5,597,571
Members
414,157
Latest member
MrBJBones

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top