Sorry Wolfgang

I am still unable to do what I want...

1. If it use auto filter, I can then select the drop down arrow and choose custom. I the select the <= XXXX (XXXX being the date). This will display the rows I want

2. If I use advance filter, I get nothing... I cant get it to use a cell value for the filter criteria.

What I want to do is just as point one, but without have to go through all the steps. I would like the criteria to be entered in cell D1 and then the macro/autofilter/VBA to use that value.

I just want to put a button on the page and link it to a macro etc rather than have the users try and figure out filters

thanks for your advice anyway I will be looking into advanced filters in more depth.

regards