autofilter with a cell as the criteria

[Bob Phillips]

Hi
I would like to be able to use an custom auto filter using the information from a static cell as the criteria.

Example; column a = order number
b = description
c = date (dd/mm/yy)

cell d1 will have a date - will be changed often

i would like to autofilter the date column 'C' but using the data in cell D1 as the filter criteria

Ideally I would like to use the <= value in D1

Any help will be appreciated

regards

If you mean without VBA, then take a look at Data>Filter>Advanced Filter.