Hi There

Total noob here !

I have 25,000 plus rows of data under the columns headed A to H in the worksheet named "Date Washed".
This raw data (so to speak) is generated by filtering and "washing" the contents of 2 other worksheets that are submitted to me weekly from remotely based administrators.

Column E of this "Date Washed" worksheet contains dates in the range 01/01/2009 to the current date, all of which appear scattered randomly throughout the full column.

I am trying (and failing !) to create a macro to find & select all the rows which contain a date in column E which is within 31 days of the current date (i.e all data collected in the last rolling months period)

These entire rows then need to be copied across to a separate new worksheet named "Last month only"

I hope this is enough info at this stage
Many thanks in advance