thanks XLD

I got the advance filter to work.

Is there a way to filter bewteen a range of dates or <= to date.

--I am beginning to think that I may need to look at a loop process to search the rows for date <= and the copy that row and paste into a new sheet and then repeat the loop until all rows have been checked.

regards
wibbers